Difference between revisions of "Accounting Procedures"
(→Import Transactions from Beanstream into GnuCash) |
m |
||
(4 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
DIYode is currently using GnuCash for our Book keeping. | DIYode is currently using GnuCash for our Book keeping. | ||
These are the procedures to keep the books current. | These are the procedures to keep the books current. | ||
+ | |||
+ | Also being considered: | ||
+ | Xero | ||
+ | Quickbooks | ||
+ | WaveApp | ||
+ | Kashoo | ||
+ | |||
+ | |||
Line 12: | Line 20: | ||
==== 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 "Reporting/Analysis">"Settlement Summary" file<br /> |
* Change Separator to "Tab"<br /> | * Change Separator to "Tab"<br /> | ||
Line 18: | Line 26: | ||
* Set the 'Date Format' to d-m-y<br /> | * Set the 'Date Format' to d-m-y<br /> | ||
* Change the column details as follows: | * Change the column details as follows: | ||
− | |||
− | |||
** date = Num<br /> | ** date = Num<br /> | ||
** merchant_name = Description<br /> | ** merchant_name = Description<br /> | ||
+ | ** daily_balance = Withdrawal<br /> | ||
+ | ** Settlement_date = Date<br /> | ||
* Account Selection = Income|Member Dues|Beanstream|Settlement<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 /> | ||
+ | Most of the errors should be status 'UND' and just reflect that no payment was made that period<br /> | ||
+ | |||
Check the imported transactions - will either be 'Auto match', 'update and reconcile', 'reconcile' | Check the imported transactions - will either be 'Auto match', 'update and reconcile', 'reconcile' | ||
Line 77: | Line 87: | ||
Create an employee record if needed.<br /> | Create an employee record if needed.<br /> | ||
Business->Employees->New Employee<br /> | Business->Employees->New Employee<br /> | ||
+ | Names is full name | ||
+ | ID# and Username are first name | ||
+ | Address can be 'Diyode' | ||
+ | |||
Create Expense Voucher for bulk Employee Expenses.<br /> | Create Expense Voucher for bulk Employee Expenses.<br /> | ||
Line 103: | Line 117: | ||
Verify invoice details. Then select proper 'Transfer Account'. <br /> | Verify invoice details. Then select proper 'Transfer Account'. <br /> | ||
*At this point gather all paper receipts and label them with the 'Voucher ID' and the payment date.<br /> | *At this point gather all paper receipts and label them with the 'Voucher ID' and the payment date.<br /> | ||
− | |||
− | |||
− | |||
− | |||
== Cashbox Process == | == Cashbox Process == |
Latest revision as of 00:50, 12 December 2015
DIYode is currently using GnuCash for our Book keeping. These are the procedures to keep the books current.
Also being considered: Xero Quickbooks WaveApp Kashoo
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 XLS file to someplace handy.
The file saves has an XLS extension but internally it is actually a CSV. Change the file extension before you continue.
Import Transactions from Beanstream into GnuCash
Import Transactions from CSV - Choose the beanstream "Reporting/Analysis">"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:
- date = Num
- merchant_name = Description
- daily_balance = Withdrawal
- Settlement_date = Date
- date = Num
- Account Selection = Income|Member Dues|Beanstream|Settlement
There will be errors. Select "Skip Errors"
Most of the errors should be status 'UND' and just reflect that no payment was made that period
Check the imported transactions - will either be 'Auto match', 'update and reconcile', 'reconcile'
Make sure there isn't an existing transaction with that date and value.
Importing CIBC online bank data to GnuCash
- Log in to CIBC online banking.
- Under |My Accounts| do |Download Transactions|
- Use |All within Date range| - specify the date range you need and select "Intuit Quicken" as your financial software.
- Click Download and put the file somewhere safe.
- open gnuCash. File->Import OFX/QFX
- The 'Generic Import transaction matcher' will open.
- The transactions should 'autoreconcile' and will have a 'check-mark' in the 'A' column.
- 'autoreconcile' won't be perfect. You will have to examine 'CIBC Business Account' and make any changes needed.
- If you cannot determine what the transaction is, place it in 'Orphan-CAD' and investigate later.
- The transactions should 'autoreconcile' and will have a 'check-mark' in the 'A' column.
Cash Dues
Enter all cash dues in to Income|Member Dues|Cash Dues.
Set the "Transfer" to Assets|Current Assets|Undeposited Funds.
Put all monies in to the 'Bank Deposit' envelope.
Go to the Member Administration, set the 'Payment Expires' date to one month* from the payment date, log the payment with a note and initials.
Donations
Add donations in income, transfer to 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.
Material Purchases
Add amounts into purchases, transfer into undeposited funds
Employee Expenses
Create an employee record if needed.
Business->Employees->New Employee
Names is full name
ID# and Username are first name
Address can be 'Diyode'
Create Expense Voucher for bulk Employee Expenses.
Business->Employees->New Employee Expense Voucher
- Leave 'Voucher ID' blank.
- Set date to date of Expense claim.
- Select Employee.
- Leave 'Billing ID' blank.
- Add Notes if required.
- OK
Voucher form opens.
Enter All expense details.
- Put in date (if exact date is not know put end of month for expense)
- Put in a valid Description
- Enter proper action
- Assign to the correct 'Expense Account'
- Quantity is usually '1'
- Unit price. enter total for expense.
Save the when completed.
- If you still need to work on the voucher then do not Post.
- If completed Post the voucher and it will show up in the chart of accounts. Put the 'Post Date' as the date the expense was re-imbursed.
- It will be 'Posted' to the Liabilities account until payed.
- You can then 'Pay Invoice'.
Verify invoice details. Then select proper 'Transfer Account'.
- At this point gather all paper receipts and label them with the 'Voucher ID' and the payment date.
Cashbox Process
Separate out: -Memberships -Materials -Donations
-Receipts outstanding
Enter each as above, make sure the money recorded in undeposited funds = money in the deposit envelope