Are there any worksheets or articles to use when verifying
the club's books? Thanks, nancy

I know there is stuff way back in NAIC archives. I have company arriving
now , but when I can I will try to find it and send it to you. In the mean
time, let me know if someone else tells you anything that helps!!
Sandy

----- Original Message -----
From: "Nancy Chamberlin" <jnchamb@bivio.com>
To: <club_cafe@bivio.com>
Sent: Monday, December 11, 2006 1:35 PM
Subject: club_cafe: Verifying books


> Are there any worksheets or articles to use when verifying
> the club's books? Thanks, nancy
>

Nancy Chamberlin writes:
> Are there any worksheets or articles to use when verifying
> the club's books? Thanks, nancy

This is our standard answer for reconciling:

There are several reports which can be used to help you reconcile
your books. The most important report is your valuation statement:

https://www.bivio.com/my-club-site/accounting/reports/valuation

Enter the date of your bank and/or broker statement on your reports
page:

https://www.bivio.com/my-club-site/accounting/reports

Make sure the cash balances agree with your bank and/or broker.

Compare the valuation statement with the bank and/or broker statements
as far back as necessary to determine the last time your records
balanced.

From there you can review the transactions in your bivio records
against the transactions reported by your bank and/or broker to see
what is missing.

To review the transactions for a particular account, you can go
to your Accounting > Accounts page and click on the name of the
account you'd like to reconcile. Make sure the transaction dates
match your statements exactly.

Another useful report is the Transaction History:

https://www.bivio.com/my-club-site/accounting/reports/transaction-history

This lists all transactions during a specified time period. It
might be the account is incorrect. Go to your Account Detail
page and edit the account.

For more information, please visit:

http://www.bivio.com/hp/accounting-reports.html
http://www.bivio.com/hp/valuation-report.html
http://www.bivio.com/hp/transaction-history-report.html
http://www.bivio.com/hp/account-detail.html
http://www.bivio.com/hp/deleting-transactions.html
http://www.bivio.com/hp/editing-transactions.html

Cheers,
Rob

Rob,

Thanks for the greast post! That's going in my keeper folder. That
questions comes up this time every year. At Crow River, we practice
diligence on a monthly basis. We make sure the bank statement cash balance
and the broker cash balance do actually balance every month. It makes year
----- Original Message -----
From: "Rob Nagler" <nagler@bivio.biz>
To: "The Club Cafe" <club_cafe@bivio.com>
Sent: Tuesday, December 12, 2006 8:36 AM
Subject: Re: club_cafe: Verifying books


> Nancy Chamberlin writes:
>> Are there any worksheets or articles to use when verifying
>> the club's books? Thanks, nancy
>
> This is our standard answer for reconciling:
>
> There are several reports which can be used to help you reconcile
> your books. The most important report is your valuation statement:
>
> https://www.bivio.com/my-club-site/accounting/reports/valuation
>
> Enter the date of your bank and/or broker statement on your reports
> page:
>
> https://www.bivio.com/my-club-site/accounting/reports
>
> Make sure the cash balances agree with your bank and/or broker.
>
> Compare the valuation statement with the bank and/or broker statements
> as far back as necessary to determine the last time your records
> balanced.
>
> From there you can review the transactions in your bivio records
> against the transactions reported by your bank and/or broker to see
> what is missing.
>
> To review the transactions for a particular account, you can go
> to your Accounting > Accounts page and click on the name of the
> account you'd like to reconcile. Make sure the transaction dates
> match your statements exactly.
>
> Another useful report is the Transaction History:
>
> https://www.bivio.com/my-club-site/accounting/reports/transaction-history
>
> This lists all transactions during a specified time period. It
> might be the account is incorrect. Go to your Account Detail
> page and edit the account.
>
> For more information, please visit:
>
> http://www.bivio.com/hp/accounting-reports.html
> http://www.bivio.com/hp/valuation-report.html
> http://www.bivio.com/hp/transaction-history-report.html
> http://www.bivio.com/hp/account-detail.html
> http://www.bivio.com/hp/deleting-transactions.html
> http://www.bivio.com/hp/editing-transactions.html
>
> Cheers,
> Rob

Oops! I hit the wrong button! <G>

Balancing bank and broker statements to the penny on a monthly basis makes
year-end auditing so much easier. Our club audits with 3 people. We run
the reports. One person checks off all the items on the bank statement
against the itemized bank account report. Another person checks of all the
items on the broker statements against the investment reports. And another
person compares deposit slips against the member reports. We make sure the
cash balances match, the member deposits match and the number of shares
match with the broker.

Then we crack open the margarita blender and start making our copies!
However, thanks to YOU, Rob, we can simply email the K-1s.

We wish you a very happy, safe, and peace filled holiday, and a very
prosperous 2007!

Lynn Ostrem, President
garbagecop@earthlink,net
Crow River Investment Club
www.bivio.com/crowriver



----- Original Message -----
From: "Rob Nagler" <nagler@bivio.biz>
To: "The Club Cafe" <club_cafe@bivio.com>
Sent: Tuesday, December 12, 2006 8:36 AM
Subject: Re: club_cafe: Verifying books


> Nancy Chamberlin writes:
>> Are there any worksheets or articles to use when verifying
>> the club's books? Thanks, nancy
>
> This is our standard answer for reconciling:
>
> There are several reports which can be used to help you reconcile
> your books. The most important report is your valuation statement:
>
> https://www.bivio.com/my-club-site/accounting/reports/valuation
>
> Enter the date of your bank and/or broker statement on your reports
> page:
>
> https://www.bivio.com/my-club-site/accounting/reports
>
> Make sure the cash balances agree with your bank and/or broker.
>
> Compare the valuation statement with the bank and/or broker statements
> as far back as necessary to determine the last time your records
> balanced.
>
> From there you can review the transactions in your bivio records
> against the transactions reported by your bank and/or broker to see
> what is missing.
>
> To review the transactions for a particular account, you can go
> to your Accounting > Accounts page and click on the name of the
> account you'd like to reconcile. Make sure the transaction dates
> match your statements exactly.
>
> Another useful report is the Transaction History:
>
> https://www.bivio.com/my-club-site/accounting/reports/transaction-history
>
> This lists all transactions during a specified time period. It
> might be the account is incorrect. Go to your Account Detail
> page and edit the account.
>
> For more information, please visit:
>
> http://www.bivio.com/hp/accounting-reports.html
> http://www.bivio.com/hp/valuation-report.html
> http://www.bivio.com/hp/transaction-history-report.html
> http://www.bivio.com/hp/account-detail.html
> http://www.bivio.com/hp/deleting-transactions.html
> http://www.bivio.com/hp/editing-transactions.html
>
> Cheers,
> Rob

Lynn Ostrem writes:
> Then we crack open the margarita blender and start making our copies!
> However, thanks to YOU, Rob, we can simply email the K-1s.

Again, let the members login to get their own K1s. This is more
secure, and it gives members more power over their accounting. Just
make sure you click the Release K1s to Members button after you audit
your books.

Rob