Accounting Procedures

From Diyode Community Workshop
Revision as of 18:18, 18 February 2014 by 64.7.147.65 (Talk)

Jump to: navigation, search

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.