Published May 2009 | Edited June 4, 2024
WHAT'S IN THIS ARTICLE
Monthly Bookkeeping Checklist | Monthend Procedures downloadable eBook | Bookkeeping Checklists downloadable eBook | Customer Payment Deposits in QuickBooks® | Deleting and Voiding Transactions in QuickBooks® | Pay Bills vs. Write Cheques in QuickBooks®
Before beginning your month end procedures, it is helpful to make your way through this monthly bookkeeping checklist. These tasks are over and above your daily and weekly bookkeeping tasks.
My bookkeeping checklists are available in a downloadable eBook format for daily, weekly, quarterly, annual and year-end tasks.
3 side-bar chats included in the Month End Procedures Manual discuss things you'll need to know while performing the month end process.
If you make customer payment deposits directly through the Make Deposits windows (Bank Deposit in QBO), you may double book an entry. How?
... (1) Booking a customer payment deposit to an income account through Make Deposits (Bank Deposit in QBO) records the income twice. Once when you generated the invoice/receipt and again when you made this deposit.
... (2) Booking a customer payment deposit to an accounts receivable through Make Deposits (Bank Deposit in QBO) records the payment twice. Once when you Received Payment/Sales Receipts and again when you made this deposit.
... The benefit to you in using Receive Payments/Sales Receipts and Undeposited Funds for all customer receipts is preventing income from being recorded twice and/or recording customer payments twice ... which of course makes the month end review easier for you.
I prefer to only delete a transaction if I do an "oops". :0) Here is a common "oops" made by beginners using QuickBooks®.
Let's say I used the wrong QuickBooks® Desktop form ...
... Before month end started, I used Write Cheques to pay a bill (it is just Cheque in QBO). Before I print the cheque, I check the vendor's balance in the Vender Center (Dashboard > Expenses > Supplier in QBO) to make sure I did the entry correctly ... and I see that the bill I'm paying was entered into Accounts Payable ... oops!
In this instance I would delete the cheque I just entered (because I hadn't printed it yet), go to Pay Bills, and pay the bill from there. Now when I check the vendor's balance, I can see that I have the correct balance.
If I hadn't caught my error, my books would have shown the expense twice on the income statement (golly no wonder I'm not making money!) and the bill still outstanding in accounts payable ... even though I'm certain I paid the bill ... and I'm thinking "why is this stupid program not working?" :0( ... when it wasn't the program at all ... but just me not following correct accounting procedures ... which is going to make my month end harder to do!
What if you didn't catch this error before you printed and sent out the cheque?
Let's say you don't catch your error until you are reconciling your vendor accounts at month end.
If you are in an open accounting period, just select the cheque you issued to pay the bill, and change the coding from an expense account to Accounts Payable. Add the vendor name in the Customer:Job column/field and say Yes to recording the changes. Then go to Pay Bills and apply the credit to the appropriate bill by clicking on Set Credits. This takes you to the Discounts & Credits window. Put a check mark on the cheque you just edited. You should be able to see the credit applied to the bill you were trying pay. If you've done it correctly, the Amount to Pay should now be zero.
If the accounting period is closed when you catch your error, book an adjusting journal entry debiting Accounts Payable and crediting the expense account. Then go to Pay Bills and apply the credit to the appropriate bill. You will have to enter the vendor name on the Accounts Payable line in order to post the journal entry exactly the same as described in the open period above.
The more recent versions of QuickBooks® actually have a warning message so this error should no longer occur ... as long as you pay attention to the message.
Good accounting procedures should be in place so that transactions are NOT voided and deleted whenever you want to ... even if the software program (like QuickBooks®) allows you to.
So here are a few basic good bookkeeping practice rules on when to delete or void a transaction in QuickBooks®.
Initially, there was NO void function in the online version of QuickBooks. However now there is. If you are in a module that doesn't have a void available do this:
✔ To void a transaction, you must manually zero out the dollar values and type in VOID at the start of the memo field and/or in the reference field.
Why would you choose to void instead of using the delete function?
✔ For me, I like my audit trail of sequential form numbers. When you delete a numbered form I end up wading through an audit trail log to see what happened to the transaction and why it was deleted.
Whenever you void a transaction(or cheque), write a note in the memo field explaining why the transaction was voided.
Remember, if you make an error and you are in an open accounting period in QuickBooks® ... you can always edit your transaction rather than delete it.
How do you edit a transaction in QuickBooks®
Find and open the transaction. Make any changes you need. Save the changes ... but do this only if the transaction has NOT been cleared in a credit card or bank reconciliation ... or printed and issued as discussed above.
How do you know if a transaction has been cleared in a reconciliation?
In the chequing account or credit card account registers .... you should see a check mark in the cleared field. This tells you it is a reconciled and cleared transaction .. and a warning message should come up telling you are editing a cleared transaction. If this happens, go ahead and change memo notes but DO NOT change any numbers ... you will put the reconciled account out!