Difference between revisions of "Accounting Procedures"
(Created page with "=== Export Settlement Summary from Beanstream === Log in to Beanstream an to to "reporting|Settlement Summary" <br /> Set the "Start" and "End" dates. Usually a complete mont...") |
|||
Line 1: | Line 1: | ||
− | === Export Settlement Summary from Beanstream === | + | ==== Export Settlement Summary from Beanstream ==== |
Log in to Beanstream an to to "reporting|Settlement Summary" <br /> | Log in to Beanstream an to to "reporting|Settlement Summary" <br /> | ||
Line 5: | Line 5: | ||
Download the file to someplace handy.<br /> | Download the file to someplace handy.<br /> | ||
− | === Import Transactions from Beanstream into GnuCash === | + | ==== Import Transactions from Beanstream into GnuCash ==== |
Import Transactions from CSV - Choose the beanstream "Settlement Summary" file<br /> | Import Transactions from CSV - Choose the beanstream "Settlement Summary" file<br /> | ||
Line 21: | Line 21: | ||
<br /> | <br /> | ||
− | === Cash Dues === | + | ==== Cash Dues ==== |
Enter all cash dues in to Income|Member Dues|Cash Dues.<br /> | Enter all cash dues in to Income|Member Dues|Cash Dues.<br /> | ||
Set the "Transfer" to Assets|Current Assets|Undeposited Funds.<br /> | Set the "Transfer" to Assets|Current Assets|Undeposited Funds.<br /> | ||
− | === Bank Deposit === | + | ==== Bank Deposit ==== |
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 /> | ||
Line 38: | Line 38: | ||
<br /> | <br /> | ||
− | === Expenses === | + | ==== Expenses ==== |
When entering expenses put in a proper Description. <br /> | When entering expenses put in a proper Description. <br /> | ||
File receipt in expense folder for the month the expense was purchased.<br /> | File receipt in expense folder for the month the expense was purchased.<br /> | ||
<br /> | <br /> |
Revision as of 18:06, 18 February 2014
Contents
Export Settlement Summary from Beanstream
Log in to Beanstream an to to "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
then 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.