Managing House Accounts: The Customer Account Transactions Report 📋💳
If your venue allows regular guests to run a tab or charge purchases directly to a personal line of credit, keeping those balances organized is key to your cash flow. The Customer Account Transactions Report is designed to answer one crucial question: "What does each house account customer owe, and what is the full history of charges against their account?"
This feature is incredibly useful for private clubs, corporate dining venues, hotel restaurants, or loyalty programs that offer stored-value house accounts. It gives you both a high-level overview of what everyone owes and a deep, transaction-by-transaction history for every single profile.
📊 What You'll See on the Report
To keep your accounting perfectly organized, the report is cleanly structured in two layers:
Layer 1: Customer Account Summary
This section gives you one row per customer, summarizing their overall account activity and current outstanding balance at a glance.
Layer 2: Transaction Detail
Nested right below the summary is a dedicated section for each customer, showing an itemized, chronological log of every single charge with full order context. Each section prominently displays the customer's name and their total outstanding balance at the top.
📖 Column Definitions: What the Numbers Mean
To make auditing easy, here is what each column tracks:
Count: The total number of separate charges posted to the customer's account during the selected timeframe.
Base $: The total amount of charges accumulated before tips are added.
Tip $: The total amount of tips added to their account charges.
Total $: The full amount charged to the account (calculated as Base $ + Tip $ ).
Balance $: The customer's current, overall outstanding balance that needs to be collected.
Last Transaction: The exact date and time of their most recent account charge.
🛠️ Strategic Ways to Use This Data
Seamless Account Reconciliation: When a billing cycle closes, use this report to easily generate accurate statements for your house account customers, showing them exactly what they owe alongside full purchase details. 🧾
Fast Collections Follow-Up: Sort your report by the Balance $ column to immediately target and contact guests who have larger outstanding bills that need to be settled. 📞
Dispute Resolution Made Easy: If a guest questions a charge on their monthly bill, Layer 2 gives you everything you need to reconstruct the moment—including the exact order number, date, time, and the specific server who rang it up. 🔍
Multi-Venue Tracking: If you operate multiple restaurant locations, the Venue column shows you exactly where each charge originated. This is perfect for handling internal charge-backs or managing localized location reporting. 🏢📍
Total Gratuity Visibility: Separating the base charge from the tip amount makes it incredibly simple to double-check that credit tips were paid out correctly to your staff, ensuring your payroll reporting is 100% accurate. 💰
🎛️ Filters Available
You can customize your report using the built-in filters in the NX Portal to zero in on exactly the information you need:
Specific Customers: Limit your report to display only one or more specific named account holders, rather than scrolling through your entire system.
Include Zero-Balance Customers: Toggle this on to view house account holders who haven't made any charges during the current period. This is highly useful for confirming that your full membership database is accounted for.
Need Help? 💡
Why is an active house account missing from the report view?
If the customer hasn't made any charges during your selected date range, they will be hidden by default to save screen space. Simply check your filter settings and make sure Include Zero-Balance Customers is turned on!
A customer paid their bill, but their "Balance $" column hasn't updated.
Make sure the payment was processed using the official "House Account Payment" tender path in the POS. If a payment is taken as standard cash or credit without being linked directly to their account profile, it won't reduce their running balance on this report.