House Account Balance Report

House Account Balance Report Overview

Reports -> Sales Reports -> "House Account Balance"

Regular customers who repeatedly buy products from the store but need to pay the total balance at the end of the month or at a specific time interval can be added as "House Accounts" in the Control Center.

So, the "House Account Balance" sales report will help track the balance of overall sales to the house account along with the adjustments.

1. Reaching the House Account Balance

To reach the "Deposits" report, follow the below steps: 

1. Step 1: Log into Control Center
   
2. Step 2: Choose Point of Sale

                                                                                                                     Figure 1.1

1. Step 3: Choose Reports
   
2. Step 4: Choose Sales Reports
   

                                                                                                                                                                      Figure 1.2

1. Step 5: Choose House Account Balance
   

By clicking "House Account Balance," you will be redirected to the "House Account Balance" page with relevant filter options.

                                                                                                                                                                      Figure 1.3

Initially, you will see the "Report data is empty" message. You need to select the date range to check the House Account Balance report sales data in the report.

2. Generating Report

When you navigate to the "House Account Balance Report" page, you need to select the date range and generate the report.

                                                                                                                                                                      Figure 2.1

After generating the report, you will see the following data based on the company (house account) in tabular format:

- Company: This column represents the name of the company associated with the house account.

- First Name & Last Name: These columns represent the first name and last name of the contact person for the house account.

- Reg #: This column represents the register number from which the sales occurred.

- Receipt #: This column represents the number of the receipt for the sales transaction.

- Balance Before: This column represents the balance before the transaction occurred.

- Adjustment: This column represents the adjusted amount of the sales transaction.

- Balance After: This column represents the balance amount after the sales transaction.

- Trans Type: This column represents the balance amount after the sales transaction.

- Transaction Date: This column represents the time span when the sales transaction occurred.

2.1 Filter House Account Balance Report

You can filter the House Account Balance data in the report by selecting a specific location or location group. From the top-right corner, there's a filter button to select the particular location(s)/location group(s).

                                                                                                                                                                      Figure 2.1.1

By clicking that button, the "Manage Filters" button will pop up to select the location/location group to filter the House Account Balance data in the report accordingly.

1. Select the store (location) records and/or location group records from the list.

2. If you have already saved the filter for the specific location/location group, you can select it by clicking the "Manage Filters" button.

                                                                                                                   Figure 2.1.2

3. Store records/location Group records can be seen on the left side. Tick the checkbox for the record and move it to the right side under "Selected List." 

4. Clear selection if you want to remove all the records under the "Selected List." You can also remove a single record from the list.

5. Once the records are selected, click the "Apply" button and generate the report, or click the "Save Filters" button to save for future use.

After generating the report with the selected store, location group, or both, the House Account Balance data can be seen as per the selection (filter location/location group).

                                                                                                                   Figure 2.1.3

In this way, you can check the House Account Balance report along with the adjusted balance.

• Related Articles

• House Accounts List Report

  House Accounts List Report Overview Regular customers who repeatedly buy products from the store but need to pay the total balance at the end of the month or at a specific time interval can be added as House Accounts in Control Center. The "House ...

• House Accounts

  House Accounts Overview House Accounts are a simple and intuitive way of tracking customer sales, with options of giving them department-level discounts, cost and pricing discounts, an in-store charge tab, or pre-programmed tax exemption options. ...

• Account Code List Report

  Account Code List Report The Account Code is a fixed-digit field used to classify financial activities and balances within the General Ledger (a set of numbered accounts that is used to keep track of financial transactions and also to prepare ...

• Discount Spiff Report

  Discount Spiff Report Reports -> Sales Reports -> "Discount Spiff" Store employees can play a vital role in selling the items, especially during checkout. Employees can earn some commission by selling the items to customers when the discount is ...

• Login/Permission Report

  Login/Permission Report Overview The "Login/Permission Report" lists users and employees along with the permissions that they are assigned. 1. Reaching the "Login/Permission Report" To reach the "Login/Permission Report," follow the below steps: Step ...