Difference between revisions of "Accounting Procedures"
(→Export Settlement Summary from Beanstream) |
(→Bank Deposit) |
||
Line 28: | Line 28: | ||
When you do a bank deposit you need to transfer the funds from the <br /> | When you do a bank deposit you need to transfer the funds from the <br /> | ||
"Undeposited Funds" account to the Business account.<br /> | "Undeposited Funds" account to the Business account.<br /> | ||
− | Click on "Undeposited Funds" <br /> | + | * Click on "Undeposited Funds" <br /> |
− | Select Actions|Transfer. <br /> | + | * Select Actions|Transfer. <br /> |
− | Type in the "Amount" and set the Date.<br /> | + | * Type in the "Amount" and set the Date.<br /> |
− | Highlight Undeposited Funds CAD as the Transfer From account and<br /> | + | * Highlight Undeposited Funds CAD as the Transfer From account and<br /> |
− | Highlight Checking CAD as the Transfer To account<br /> | + | * Highlight Checking CAD as the Transfer To account<br /> |
− | + | * Click OK.<br /> | |
+ | |||
This transfer should line up with the Bank Deposit book.<br /> | This transfer should line up with the Bank Deposit book.<br /> | ||
<br /> | <br /> |
Revision as of 18:17, 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
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.