Difference between revisions of "Accounting Procedures"
From Diyode Community Workshop
(→Bank Deposit) |
(→Import Transactions from Beanstream into GnuCash) |
||
Line 8: | Line 8: | ||
Import Transactions from CSV - Choose the beanstream "Settlement Summary" file<br /> | Import Transactions from CSV - Choose the beanstream "Settlement Summary" file<br /> | ||
− | |||
− | |||
− | Settlement_date = Date<br /> | + | * Change Separator to "Tab"<br /> |
− | daily_balance = Withdrawal<br /> | + | * Start import on row = 2<br /> |
− | date = Num<br /> | + | ** Settlement_date = Date<br /> |
− | merchant_name = Description<br /> | + | ** daily_balance = Withdrawal<br /> |
− | + | ** date = Num<br /> | |
− | Account Selection = Income|Member Dues|Beanstream|Settlement<br /> | + | ** merchant_name = Description<br /> |
+ | * Account Selection = Income|Member Dues|Beanstream|Settlement<br /> | ||
There will be errors. Select "Skip Errors"<br /> | There will be errors. Select "Skip Errors"<br /> |
Revision as of 18:18, 18 February 2014
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
- Settlement_date = Date
- 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.