๐ Overview
Accurate month-end accounting starts with having the right accounts in place. Balance sheet accounts are accounts in your accounting system used to track money moving in and out of your organization. This article walks you through the recommended accounts to set up, how clearing accounts simplify your cash transaction entries, and how to use the GL Report to post month-end sales transactions.
๐ฐ Recommended Accounts to Set Up
Click the arrow to learn more about recommended account setup
Click the arrow to learn more about recommended account setup
We recommend setting up the following accounts on your balance sheet:
Dash Customer AR
Dash NSF Checks
Dash Refund Checks
Each of these accounts should be at zero at month end, unless you can identify specific items causing a remaining balance. Examples of reasons a balance may exist in each account are as follows:
Dash Customer AR - if you have collected a partial payment from a customer. The balance remaining in this account should match your Customer AR Report.
Dash NSF Checks - if you have recorded an NSF check in your accounting system but have not yet recorded it in the system, or vice versa. Either way, you should be able to identify the specific check(s) making up the remaining balance.
Dash Refund Checks - refund(s) entered in your accounting system that have not yet been entered in the system. You should be able to identify the specific check(s) making up this balance.
๐ Understanding Clearing Accounts
Click the arrow to learn more about how clearing accounts work
Click the arrow to learn more about how clearing accounts work
Clearing accounts are a simple way to enter different cash transactions alongside the related sales detail. The table below illustrates how these work:
Cash | Clearing Acct | Revenue Detail | |
Daily Deposit | Debit $10,000 | Credit ($10,000) | |
GL Report Entry | Debit $10,000 | Credit ($10,000) | |
Balance | Debit $10,000 | $0 | Credit ($10,000) |
You may wonder why you wouldn't simply enter Cash and Revenue directly. The main reason is that multiple types of transactions affect your cash balance, including:
Bank deposit entries
Credit card deposit entries
NSF checks
Refund checks
By using a clearing account, you only need to reference this one account in your accounting system rather than managing detailed revenue line items for each cash transaction. When these are entered in the system, all revenue details are tracked and summarized in the GL Report.
You can also enter your revenue detail once a month rather than daily.
โ๏ธ Note: Always make sure any entry you make to Cash matches what will appear on your bank statement. This simplifies your bank reconciliation process.
๐งพ Posting Sales Transactions
Click the arrow to learn how to post month-end sales transactions
Click the arrow to learn how to post month-end sales transactions
At the end of the month, run a GL Report for that month. Remember to choose to ignore team credits when running the GL Report if you do not want this level of detail on your financial statements.
Then make the following entry:
DR Dash Customer AR
CR League Revenue
CR Class Revenue
CR Pro Shop Sales
CR Membership Sales
CR Sales Tax Payable
Enter as many revenue types as you want to track in your accounting system. You can enter as detailed as Snickers, Mounds, Skittles, etc., but we don't recommend that level of detail. The system will give you the sales for any product item you create.
The total of this report should match your Sales Report totals for the month, unless you use the Partial Payment function. The only difference in the accounting will be credit card sales that have not settled by midnight of the last day of the month. Those sales will post to your bank based on the settlement time of your merchant service. If you don't use the Customer Credit function, your Dash A/R account balance should only carry a debit balance for credit card sales not yet settled.
โ๏ธ Note: If your GL Report shows "Unclassified Products," you will want to properly assign GL Codes to those products before running this report. Unclassified Products are items that have not been assigned a GL Code and will appear as N/A on the GL Report.
