Difference between revisions of "Accounting Procedures"

From Diyode Community Workshop
Jump to: navigation, search
(Import Transactions from Beanstream into GnuCash)
(Import Transactions from Beanstream into GnuCash)
Line 16: Line 16:
 
* Change Separator to "Tab"<br />
 
* Change Separator to "Tab"<br />
 
* Start import on row = 2<br />
 
* Start import on row = 2<br />
* Set the 'Date Format' to m-d-y<br />
+
* Set the 'Date Format' to d-m-y<br />
 
* Change the column details as follows:
 
* Change the column details as follows:
 
** Settlement_date = Date<br />
 
** Settlement_date = Date<br />

Revision as of 12:39, 3 November 2014

DIYode is currently using GnuCash for our Book keeping. These are the procedures to keep the books current.


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 XLS file to someplace handy.
You will have to convert the XLS to a CSV for GnuCash to be able to import it.

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
  • Set the 'Date Format' to d-m-y
  • Change the column details as follows:
    • 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.