Skip to main content

Month-End Sales & GL Posting

Set up balance sheet clearing accounts and post month-end sales transactions using the GL Report in your accounting system.

Written by Angel Horowitz

๐Ÿ“ 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

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

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

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.

Did this answer your question?