House Account Report

October 01, 2024October 01, 2024

The House Account Report shows details about all customer house account (store credit) balances. Explore what this useful report can do for you!

Image showing how to access the House Account report in the Bottle POS Admin app.

To get to this report, log in to your Admin and go to Reports. Select the House Account Report in the report selection drop-list.

 

The House Account Report

Image showing upper area of the House Account report of the Bottle POS Admin app.

  1. Home  Click to navigate away from Reports back to your Dashboard.
  2. Report Drop-List  Click and select House Account Report here to view in-store credit account details across a specified range of dates for your customers.
  3. Range  This is the Date Range used in the report calculations in the table below. Click in this box to select another date or dates from a pop-up window as shown here:

Image showing an example of the calendar selection used for reporting in the Bottle POS Admin app.

  1. Refresh  Click to Refresh the page if House Account data might have changed since you first opened the report.
  2. Export CSV Click to Export all the data in the report to a CSV file (spreadsheet).
  3. Print  Click to Print a copy of the current page of the report to a PDF file or to a printer connected to your computer.

 

The Data Table

Image showing the House Account report of the Bottle POS Admin app.

  1. Search  Enter any text here to Search for a specific row in the data table. You can search by keyword or numeric amounts. For example, you might start typing 'Barb' to filter the search results to only Barb's House Account. The software starts searching for matches as soon as you start typing.
  2. Show Entries  Click and select 10, 25, 50, or 100 to show that many results per page on your report. 
  3. Name  This column displays the Name of each customer who has an open House Account for the specified date range. Click a name to open the Report House Ledger Transactions window showing that person's transactions during the date range you've chosen (more details below).
  4. Opening  This column displays the House Account balance at the start of the date range you've chosen.
  5. Credit  This column displays the amount the customer has charged to their House Account during the date range you've chosen.
  6. Collection  This column displays the amount the customer has paid off from their house account during the date range you've chosen. 
  7. Closing  This column displays the balance of the House Account at the end of the date range you've chosen.
  8. Sort  Example of the Sort icon on the House Account Report. The Sort icon displays in the header row of any sortable column. The currently sorted column displays in blue, as shown on the left. All other sortable columns show this icon in gray, as shown on the right. Click the column header in any sortable column to sort the table alphabetically or numerically, depending on the information in that column. Click it again to reverse the sort order.
  9. Total / Grand Total  The Total row tabulates each column for the current page of customer House Accounts. The Grand Total row tabulates each column across all pages in the report.
  10. Previous / Next  Click Previous, Next, or a Page Number to navigate to another page of report results.

 

Report House Ledger Transactions

If you click a customer's name in the House Account Report the Report House Ledger Transactions window will open and give you full details of all transactions involving the customer's House Account during your selected date range, as pictured below.

Image showing the House Account report of the Bottle POS Admin app.

  1. Search  You can search the House Account transaction data by Ref Number (using the digits after the final hyphen), by customer Name, or by any numeric data in the data table. As soon as you start entering text, the table will filter down to matching results.
  2. Data Table In the data table you can see all transactions involving the customer's House Account for the filtered date range. The table shows the Transaction Reference ID, Date & Time, Username of the staff member that processed the transaction, Credit dollar amount, Payments dollar amount, and the Running Balance of the House Account at the time of each transaction.
  3. Details  Click the Details button on the far right of each transaction's line to view the full Transaction Details window. For transactions in which a House Account was used to charge a credit balance for a purchase, the Payments tab will show the amount. For transactions in which a payment was made toward a House Account balance, the Items tab will show the amount.

    Image showing the Transaction Details window opened from the House Account report of the Bottle POS Admin app.

Related Topics 

Guide to the Admin Reports

How to Set Up and Use a Customer House Account

 

Frequently Asked Questions

Q: If I delete a sale which was paid for with a House Account, will the customer's house account balance be removed?

A: No. The only way to remove or reduce a customer's balance is to pay it off.

 

Q: Can I print my reports from the Admin?

A: Yes. If you have a printer connected to your device, you can click the Print button on the top right of the report page to print the report you are viewing.

 

Q: I have a question, but I can't find my answer here, how do I get more assistance?

A: You can ask any question at the number below. Contact our 24/7 support team at: (877) 381-4087