The Detail of the General Ledger Report:
Your most valuable analytic tool
How in the world could anyone working in accounting get along without a Detail of the General Ledger report? That would be like working with your hands tied and your eyes blindfolded. Without this report you would have a very difficult time determining how a final balance in a particular account was derived. Here is why:
Picture this: Back in the not-to-distant past (before computers really caught on) we accountants recorded each transaction of the business manually into a great big hard-bound, three-leaf binder book with yellow pre-printed ledger pages. Obviously, this was a very time-consuming, tedious process. Each page not only recorded the numbers associated with the transaction, it also recorded where the numbers came from, the date, and, when appropriate, a very brief note to the side describing additional detail. Here is an example of a general ledger account page:
Account 1010 – Cash-in-Bank
| Date | Source | Debit | Credit | Balance |
| 12/31 | Balance Forward | 3,450.21 | ||
| 01/05 | General Journal pg 2 | 54.00 | 3,504.21 | |
| 01/17 | General Journal pg 4 | 27.00 | 3,477.21 | |
| 01/31 | Cash Receipts pg1 | 8,025.34 | 11,502.55 | |
| 01/31 | Cash Disbursements pg 4 | 7,945.87 | 3,556.68 |
Transactions may come from a variety of journals, but they all pyramid into the General Ledger. I use the word “pyramid” because it is helpful to visualize the shape of a pyramid with all the source documents spread out at the base. The information is being summarized from each document and “migrates” upward to the General Ledger and eventually to the financial statements, which are at the top of the pyramid:
Fin State
Trial Balance
General Ledger
Gen Jour, Cash Rec, Cash Disb, Acct Rec, Acct Pay
Sales Invoices, Purchase Invoices, Bank Rec, Check Register
If I wanted to find out how a particular balance came to be, all I had to do was look at the detail on the general ledger page. That detail would then tell me which source documents contained the numbers that contributed to the final balance. I did not have search all over kingdom come to find what I was looking for.
Nowadays, your computer accounting software should give you a report of the detail in your General Ledger that is laid out as cleanly and clearly as presented above. Just like you would find in a manual general ledger. The report should not be encumbered with all kinds of other information that makes it hard to decipher. Some software programs don’t call this report a Detail of the General Ledger, they call it a transaction report or something similar.
Furthermore, you should be able to print a report for any period your heart desires, for instance: a year-to-date report; from February to July; for just one month; or whatever. You need that flexibility. If you need to see all twelve months of activity for a particular account, then you need to see all twelve months. You should not have to print out each month separately and then manually piece them together. And, if you only need to look at one month, you don’t want to have to print out the entire year.
A good report will enable you to use it as an analytic tool to find mistakes. Let’s assume that after printing your financial statements you looked at the Cash-in-Bank account and it said the balance was $3,556.38. Being the good accountant that you are, you verified that balance with the bank reconciliation balance and found that it said the balance should be $3,583.38. The difference between the two totals is $27.00. Your first step should be to run a Detail of the General Ledger report for the month, which you do and it is our example above. The first thing you notice is a $27.00 credit entry. This is suspicious and worth investigating. You can see that this entry came from the General Journal so you turn to page 4. Let’s hypothesize and assume that you really meant for this credit entry to go to Employee Advance, which is 1110. You simply wrote the wrong GL Account number.
We used to call this procedure “smoking out the error”. Sometimes the errors are easy to find, sometimes not so easy. The process consists of verifying the final balances that are on the financial statements. What is in the General Ledger should be what is on the financial statements. Therefore, you must use another document as a means of verifying the account balance. In our example above, we used the Bank Reconciliation. Other documents used to verify balances could be the Accounts Payable Ledger, Accounts Receivable Ledger, Sales Tax Report, Payroll History Report, Inventory Control Report, Notes Payable Amortization Schedule, and so on.
Just like a carpenter who uses a level before nailing up a board, you will want to verify your balances with these other control reports before accepting the financial statements as being correct. If the board isn’t level, the carpenter must figure out why. If an account balance is different than the balance found on the control document, then use your analytical tool called the Detail of the General Ledger Report to discover why.



Replenishing Petty Cash
30-Jan-05How to properly replenish petty cash has been a surce of confusion for many small business owners. As a practicing accountant, I find clients making the same mistake constantly, and it come from not understanding the full concept of petty cash. The concept is not difficult to understand; you just need to make sure you understand it.
First, think about what you are doing. You take a certain amount of money out of the bank; let’s say $100, and put it into a cash box. Remember, that the general ledger account, Cash-in-Bank, is an asset. An asset, you may recall, if you have taken my Accounting for Non-Accountants course, is an unused economic resource that your business owns (has possession or controf of). All you have done, is shift $100 from Cash-in Bank to another asset account called Petty Cash. You deplete the cash in the box when you purchase such items as postage, office supplies, meals, gas for an auto, etc. When most of the cash is gone, you must replenish the fund. You do that by withdrawing more cash from the bank for the amount that has been depleted; let’s say $92.50. You should have $92.50 in receipts for expenses in the box. Those expenses are posted to their respective categories and the offset is, of course, Cash. Here is the journal entry:
DESCRIPTION DEBIT CREDITThe mistake occurs when you try to do this:
DESCRIPTION DEBIT CREDITCash 92.50If you went with this second journal entry, you would end up with $192.50 in the Petty Cash account, which is an asset on your balance sheet, and zero in the expense accounts for postage, office, meals, and auto. This doesn’t seem right, does it? If you audited the petty cash box you would not find $192.50 in cash, vouchers and receipts. You would only find $100.00. The Petty Cash amount remains the same as originally established, unless you purposefully decide to increase it. Otherwise, petty cash expenditures must be recorded to their appropriate expense categories.
Go to the articles section of the blog to read my article, “Why Petty Cash” to find out why using a petty cash fund is a good accounting practice.