For businesses, especially in the restaurant and retail sectors, a Point of Sale (POS) system is the central hub for daily transactions. A key component of this system is the "Z-out" report. This report is generated at the close of a business day and effectively "zeros out" the register, summarizing all the sales activity for that period. This provides a snapshot of total sales, broken down by payment method, and is crucial for accurate accounting when your POS system doesn't directly integrate with your accounting software.
The "Z" in Z-out stands for zero. Historically, cash registers were zeroed out at the end of the day to prepare for the next day's business. This end-of-day report provides a comprehensive summary of all transactions, including:
Total Sales: This is often categorized into taxable and non-taxable sales. Depending on the business, it may be further broken down into categories like food, beverage, or alcohol sales.
Payment Methods: The report details how customers paid, such as cash, credit cards (which may be itemized by card type like Visa, Mastercard, American Express), checks, and gift cards.
Sales Tax: The total amount of sales tax collected is also listed.
Discounts and Returns: Any discounts applied or returns processed during the day are typically included.
There is also an "X-out" report, which provides a similar summary but for a specific period within the day, such as a shift change, without resetting the daily totals.
The goal is to mirror the information from the Z-out report in your accounting software, such as QuickBooks. Instead of creating a complex journal entry from scratch, a recommended method is to use a "daily sales summary" or a sales receipt. This approach simplifies the process and ensures that your sales, liabilities, and assets are correctly recorded.
Here's a step-by-step guide to creating a daily sales summary:
Set Up Your Items: In your accounting software, you'll need to create products or services that correspond to the categories on your Z-out report. This includes items for different types of sales (e.g., "Taxable Sales," "Non-Taxable Sales") and for each payment method (e.g., "Cash Received," "Credit Card Received").
Create a Daily Sales Customer: To keep things organized, create a generic customer in your accounting system, such as "Daily Sales" or "Counter Sales." All your daily sales summaries will be recorded under this customer.
Enter the Sales Information: Create a new sales receipt for your "Daily Sales" customer. On this receipt, you will enter the sales information from your Z-out report as individual line items. For example:
Taxable Sales: Enter the total amount of taxable sales for the day. Your accounting software will then calculate the sales tax based on the rate you have set up.
Non-Taxable Sales: Add a line for the total non-taxable sales.
Enter the Payment Methods as Negative Amounts: This is a critical step. To balance the sales receipt to zero, you will enter the amounts for each payment method as negative numbers. This signifies the tender received against the sales. For example:
Cash Received: Enter the total cash received as a negative amount.
Credit Card Received: Enter the total credit card payments as a negative amount. You can choose to have a single line for all credit cards or separate lines for each type, which can be helpful for reconciling deposits later.
The final balance of the sales receipt should be zero, reflecting that all sales have been accounted for by the payments received.
Once the daily sales receipt is saved, the accounting for the payments begins. The amounts for cash and credit cards will typically be recorded in an "Undeposited Funds" account.
Cash Deposits: When you physically deposit the cash at the bank, you will record a bank deposit in your accounting software, moving the funds from "Undeposited Funds" to your bank account. It's recommended to do this daily to avoid confusion.
Credit Card Deposits: Credit card payments will be deposited into your bank account by the processing company. These deposits can then be matched to the amounts in your "Undeposited Funds" account. Be aware that different credit card companies may have different deposit schedules.
When it comes to inventory, it's generally best to let your POS system be the single source of truth for inventory tracking. Attempting to manage inventory in both your POS and accounting software can lead to discrepancies. Instead, you can periodically make a journal entry to update your inventory and cost of goods sold in your accounting software based on reports from your POS system. This keeps your financial records accurate without the need for real-time inventory syncing.