Difference between revisions of "Accounting Procedures"

Revision as of 18:18, 18 February 2014

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.