Difference between revisions of "Accounting Procedures"

From Diyode Community Workshop
Jump to: navigation, search
m
 
(10 intermediate revisions by 2 users 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:
** Settlement_date = Date<br />
 
** daily_balance = Withdrawal<br />
 
 
** 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'
 +
Make sure there isn't an existing transaction with that date and value.
  
 
==== Importing CIBC online bank data to GnuCash ====
 
==== Importing CIBC online bank data to GnuCash ====
Line 42: Line 55:
 
Set the "Transfer" to Assets|Current Assets|Undeposited Funds.<br />
 
Set the "Transfer" to Assets|Current Assets|Undeposited Funds.<br />
 
Put all monies in to the 'Bank Deposit' envelope.<br />
 
Put all monies in to the 'Bank Deposit' envelope.<br />
 +
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.<br />
 +
 +
==== Donations ====
 +
Add donations in income,
 +
transfer to undeposited funds
  
 
==== Bank Deposit ====
 
==== Bank Deposit ====
Line 60: Line 78:
 
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 />
 +
 +
==== Material Purchases ====
 +
Add amounts into purchases, transfer into undeposited funds
  
  
Line 66: 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 78: Line 103:
 
Voucher form opens.<br />
 
Voucher form opens.<br />
 
Enter All expense details.<br />
 
Enter All expense details.<br />
**Put in date (if exact date is not know put end of month for expense)<br />
+
*Put in date (if exact date is not know put end of month for expense)<br />
**Put in a valid Description<br />
+
*Put in a valid Description<br />
**Enter proper action<br />
+
*Enter proper action<br />
**Assign to the correct 'Expense Account'<br />
+
*Assign to the correct 'Expense Account'<br />
**Quantity is usually '1'<br />
+
*Quantity is usually '1'<br />
**Unit price. enter total for expense.<br />
+
*Unit price. enter total for expense.<br />
  
 
Save the when completed.<br />
 
Save the when completed.<br />
Line 92: 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 ==
 +
 +
Separate out:
 +
-Memberships
 +
-Materials
 +
-Donations
 +
 +
-Receipts outstanding
 +
 +
 +
Enter each as above, make sure the money recorded in undeposited funds = money in the deposit envelope

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



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
  • 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.

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