Accounting Procedures
Contents
Export Settlement Summary from Beanstream
Log in to Beanstream and go to left menu option "reporting|Settlement Summary"
Set the "Start" and "End" dates. Usually a complete month. Click "Refresh"
Download the file to someplace handy.
Import Transactions from Beanstream into GnuCash
Import Transactions from CSV - Choose the beanstream "Settlement Summary" file
Change Separator to "Tab"
Start import on row = 2
Settlement_date = Date
daily_balance = Withdrawal
date = Num
merchant_name = Description
Account Selection = Income|Member Dues|Beanstream|Settlement
There will be errors. Select "Skip Errors"
Cash Dues
Enter all cash dues in to Income|Member Dues|Cash Dues.
Set the "Transfer" to Assets|Current Assets|Undeposited Funds.
Bank Deposit
When you do a bank deposit you need to transfer the funds from the
"Undeposited Funds" account to the Business account.
- Click on "Undeposited Funds"
- Select Actions|Transfer.
- Type in the "Amount" and set the Date.
- Highlight Undeposited Funds CAD as the Transfer From account and
- Highlight Checking CAD as the Transfer To account
- Click OK.
This transfer should line up with the Bank Deposit book.
Expenses
When entering expenses put in a proper Description.
File receipt in expense folder for the month the expense was purchased.