Difference between revisions of "Recording Daily Transactions in Gnucash"

From FreekiWiki
Jump to navigation Jump to search
Line 17: Line 17:
 
* So now we've tracked incoming donations AND the actual amount of money in the till at the end of the day.  The '''Balance'' should read $300.00.  If it ''doesn't'', then read on:
 
* So now we've tracked incoming donations AND the actual amount of money in the till at the end of the day.  The '''Balance'' should read $300.00.  If it ''doesn't'', then read on:
 
:* What does the Till Worksheet say under '''D - Cash out*'''?  If there were any reimbursements or IOUs, (ideally) they would be detailed in the '''Cash out notes''' section.
 
:* What does the Till Worksheet say under '''D - Cash out*'''?  If there were any reimbursements or IOUs, (ideally) they would be detailed in the '''Cash out notes''' section.
:* Did any money come in that was not recorded in the database?  Make sure that it is entered either as misc cash in (checks go here as well) or misc credit in and is itemized properly.
+
:* Did any money come in that was not recorded in the database such as cash-only donations or tech support income?  Make sure that it is entered either as misc cash in (checks go here as well) or misc credit in and is itemized properly.
 
:* see [[Recording_Income_and_Expense_Transactions_in_Gnucash|here]] for more info on recording income and expenses
 
:* see [[Recording_Income_and_Expense_Transactions_in_Gnucash|here]] for more info on recording income and expenses
 
:* Can't find the discrepancy?  Then write it off and enter the discrepancy as an overage or a short till.
 
:* Can't find the discrepancy?  Then write it off and enter the discrepancy as an overage or a short till.

Revision as of 14:03, 27 February 2010

In Gnucash, record the transactions from the day. (You need to be a member of the beancounters group on ryukin to do this.) These are frequently called "the Dailies."

Note on Double Entry Bookkeeping

  • check out this page for some basics of Free Geek accounting.

Start with Credit/Debit for Front Desk and Thrift Store

  • When people pay with credit or debit cards, this payment is automatically shuttled into our checking account (unlike cash and checks which we physically deposit at the Bank). This is why we track credit/debit payments separately in the books
  • Credit/Debit payments are entered into Assets:Bank:Main Checking. There are two entries per day, one for the Front Desk and one for the Thrift Store
  • Make sure you enter the amount from the credit card summary slips, not from the database report.

Then Enter the Front Desk Transactions

  • Bookkeepers keep track of how money comes and goes at the Front Desk till. In addition to credit and debit cards (see above),the Front Desk receives cash, checks, and some coins. In addition, when staff members need to be reimbursed (for mileage, buying a plunger for the toilet, etc.) they generally go to the Front Desk for this.
  • Front Desk transactions are entered into Assets:Cash:Front Desk
  • First off, we track the cash and checks that the database says we received that day. On the Income Report printout, this line is called Till Total. Enter this in the books (under Assets:Cash:Front Desk) as Cash Income. Please note the difference between mandatory Fees (i.e. monitor or pickup fees) and Suggested donations.
  • Secondly, we track the money that the Front Desk staff actually ends up with at the end of the day. This amount should be equal to the Till Total amount, but it may be different because someone was reimbursed or someone bought a sticker. This amount is noted on the Till Worksheet for the Front Desk as C - Money for Safe. Why is it called Money for Safe? Because this is the amount that is physically transferred into the Safe, as part of a daily deposit.
  • So, in the books (still under Assets:Cash:Front Desk), enter a Daily Transfer, using the amount on the Till Worksheet next to C - Money for Safe
  • So now we've tracked incoming donations AND the actual amount of money in the till at the end of the day. The 'Balance should read $300.00. If it doesn't, then read on:
  • What does the Till Worksheet say under D - Cash out*? If there were any reimbursements or IOUs, (ideally) they would be detailed in the Cash out notes section.
  • Did any money come in that was not recorded in the database such as cash-only donations or tech support income? Make sure that it is entered either as misc cash in (checks go here as well) or misc credit in and is itemized properly.
  • see here for more info on recording income and expenses
  • Can't find the discrepancy? Then write it off and enter the discrepancy as an overage or a short till.

Now Enter the Thrift Store Transactions

  • Bookkeepers keep track of how money comes and goes at the Thrift Store till. In addition to credit and debit cards (see above), the Thrift Store receives cash, coins, and very rarely checks (people have to be approved to pay by check). In addition, when staff members need to be reimbursed (for mileage, buying a plunger for the toilet, etc.) they can go to the Thrift Store for this.
  • Thrift Store transactions are entered into Assets:Cash:Thrift Store
  • First off, we track the cash that the database says we received that day. On the Income Report printout, this line is called Till Total. Enter this in the books (under Assets:Cash:Thrift Store) as Cash Sales. Please note the differences between Bulk, Friend, No Discount, and Volunteer - this is not always in the same order!
  • Secondly, we track the money that the Thrift Store staff actually ends up with at the end of the day. This amount should be equal to the Till Total amount, but it may be different because someone was reimbursed. This amount is noted on the Till Worksheet for the Thrift Store as C - Money for Safe. Why is it called Money for Safe? Because this is the amount that is physically transferred into the Safe, as part of a daily deposit.
  • So, in the books (still under Assets:Cash:Thrift Store), enter a Daily Transfer, using the amount on the Till Worksheet next to C - Money for Safe
  • So now we've tracked sales AND the actual amount of money in the till at the end of the day. The 'Balance should read $600.00 (because, unlike the Front Desk, there are two tills in the Thrift Store). If it doesn't, then read on:
  • What does the Till Worksheet say under D - Cash out*? If there were any reimbursements, (ideally) they would be detailed in the Cash out notes section.
  • see here for more info on recording income and expenses
  • Can't find the discrepancy? Then write it off and enter the discrepancy as an overage or a short till.

And then invoices

If there are any amounts for invoices go to this page


See Also