House Account Balance Report

House Account Balance Report

House Account Balance Report Overview

Regular customers or businesses who make frequent purchases and settle their total balance at the end of the month or at a designated time interval can be categorized as "House Accounts" in Control Center. Consequently, the "House Account Balance Report" is useful for monitoring the cumulative sales balance of the house accounts, including any adjustments.

This article includes information about:
  1. How to generate a "House Account Balance Report."
  2. How to apply the customer filter options to filter the report data.
  3. How to automate (schedule) or print a report.
  4. How to mark the report as a favorite report.

1. Reaching the "House Account Balance Report" 

  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Sales Reports
  5. Step 5: Choose House Account Balance
Figure 1.1 below will help you understand the navigation better.


Figure 1.1

See Figure 1.1 above for the navigation required. When you click "House Account Balance," the House Account Balance Report screen will open with relevant filtering and sorting options, as Figure 1.2 shows.


 Figure 1.2

The report data will be empty initially. You must choose a date range, select the appropriate filters, and click "Generate Report" to generate a report. 

2. Generating the "House Account Balance Report"

Please follow the steps below to generate the "House Account Balance Report" that meets your requirements: 
  1. Navigate to the House Account Balance Report screen.
  2. Select the date range and click "Generate Report" to view the House Account Balance Report for the selected date range.
    1. You can use the Date Range & Presets and Stores and Location Groups filters to create a report that meets your requirements. You can use multiple filters to make the report more specific. Please refer to point 3. Report Filter Options to learn more about these filters.
    2. Click "Generate Report" whenever you change your selection in any field to view the updated report. 
  3. When you click the "Generate Report" button after selecting the date range, the system will show the house account-wise sales records, as Figure 2.1 shows.

 Figure 2.1

Report Fields:
  1. Company: This column represents the name of the company associated with the house account.
  2. First Name & Last Name: These columns represent the first name and last name of the contact person for the house account.
  3. Reg #: This column represents the register number from which the sales occurred.
  4. Receipt #: This column represents the number of the receipt for the sales transaction.
  5. Balance Before: This column represents the balance before the transaction occurred.
  6. Adjustment: This column represents the adjusted amount of the sales transaction.
  7. Balance After: This column represents the balance amount after the sales transaction.
  8. Trans Type: This column represents the balance amount after the sales transaction.
  9. Transaction Date: This column represents the time span when the sales transaction occurred.

3. Report Filter Options

FTx Cloud POS lets you view the House Account Balance Report records according to your preferences using various filter options. You can configure the report with any single filter or combination of multiple filters. The filters are highlighted in Figure 3.1.

 Figure 3.1
1: Report Filter: 
  1. Date Range & Presets: This filter lets you select the report's time interval. 3.1 Date Range & Presets explains further details.  
2: Store and Location Filter: This filter lets you view the report for the selected stores (locations) or location groups. 3.2 Filter Store and Location Groups explains further details. 

3.1. Date Range & Presets

Date Range

Please follow the steps below to select the report's required date range and time interval:
  1. Click inside the Start Date field. The drop-down calendar will appear as shown in Figure 3.1.1.
  2. Select the specific date and time. You can also manually enter the date in the MM/DD/YYYY format.
  3. Click inside the End Date field and follow the same process. 
  4. After making the appropriate selections for other filters, click on "Generate Report."

 Figure 3.1.1

Presets
  1. Use the Presets drop-down to select the specific duration/interval, i.e., Today, Yesterday, This Week, Last Week, etc., to generate the report as shown in Figure 3.1.2.
  1. Please click on the required timeframe and click "Generate Report." The system will generate and show the report based on your selection. 

Figure 3.1.2

3.2 Filter Stores and Locations

The Store and Location Group filter lets you view the report for selected stores (locations) and location groups. Please follow the steps below to apply the Store & Location Group filter.
  1. Click the "No filter selected" button in the top right, highlighted in Figure 3.2.1.

 Figure 3.2.1
  1. The Manage Filters screen will appear, as Figure 3.2.2 shows. 

Figure 3.2.2
  1. 1: Manage Filters Drop-Down: The drop-down shows the list of saved custom filters, if there are any. Select the required filter from the drop-down and click the "Apply" button to apply it. The "Manage Filters" button next to this drop-down helps you open the Manage Saved Filters screen. 3.2.1 Save and Manage Location Filters explains more details.
  2. 2: Parameter Tabs: You will see two tabs: Store and Location Group. Select the required tab, e.g., Store, to create or apply a custom filter specific to the selected stores. 
  3. 3: Use this Search box to search for a specific location. 
  4. 4: Use this drop-down to view the results (stores or location groups) based on Pricebook Zone. 
  5. 5: Use this drop-down to view the results (stores or location groups) based on three parameters: All Locations, Only Active, and Only Deleted. 
  6. 6: Results: This section shows the list of selected parameters. For example, if you have chosen the "Store" tab, it will show a list of stores.  
  7. 7: Selection Checkboxes: You must select the required stores by ticking the checkbox. 
  8. 8: Arrow: Click the green Arrow button to move the selected stores to the Selected List. 
  1. The Manage Filters screen will appear, as Figure 3.2.3 shows. 

Figure 3.2.3
  1. 1: Click the "Clear Selection" button to remove the whole selection. To remove any record from the list, click the Remove (x) icon.
  2. 2: Click "Apply" to apply the selection. You can click the "Save Filters" button to save the custom filter for future use. 3.2.1 Save and Manage Location Filters explains the details.

3.2.1 Save and Manage Location Filters

You can also save the configured custom filters for future use.
  1. Click the "Save Filters" button shown in Figure 3.2.3.
  2. The Name screen will appear as shown in Figure 3.2.1.1. 
  3. Enter the name of the custom filter and click "OK." A success message will appear, and the custom filter will be saved. 
    1. You can see this custom filter listed in the Manage Filters drop-down.

Figure 3.2.1.1
  1. You can use the saved custom filter from the Manage Filters drop-down whenever needed, and you can delete them when you no longer need them. Open the Manage Filters screen again and use the steps shown in Figure 3.2.1.2 according to your requirements.

Figure 3.2.1.2
  1. 1: Saved Filter Drop-Down: All saved custom filters will appear in the Saved Filter drop-down. You can select the required custom filter and click "Apply." 
  2. 2: Manage Filters: Use the "Manage Filters" button to view and manage the saved filters. The "Manage Saved Filters" pop-up screen will appear when you click the "Manage Filters" button. 
  3. 3: Filter Name: The list shows all saved custom filters. Click on a filter's name to select it.     
  4. 4: Click "Select Filter" or "Delete."
    1. "Select Filter": Click on the filter's name, then click the "Select Filter" button to select any filter from the list.
    2. "Delete": Use the "Delete" button to remove the filter no longer required from the list. Click on the filter's name and then the "Delete" button. A warning message will appear. Click "OK."
  1. Similarly, you can filter the records by selecting the location group(s). When you set up the filters for locations (stores) and location groups, you can see the details chosen by hovering the mouse cursor over the Selected Stores button, as shown in Figure 3.2.1.3.

 Figure 3.2.1.3
​

4. Scheduling a Report

FTx Cloud POS supports report automation. You can configure a report and schedule it. The system will send the scheduled report to the indicated email addresses at the defined frequencies (daily, weekly, bi-weekly, monthly, quarterly, etc.). 

Please refer to Scheduling a Report to learn how to schedule a report.

5. Printing/Exporting a Report 

You can print or export any report according to your requirements. When you use the Print function, the system creates and opens the report's PDF file in a new tab. You can download the soft copy or print the paper copy according to your requirements. 

Please refer to Printing a Report to learn how to print or export a report. 

6. Manage Favorites 

FTx Cloud POS allows quick access to the reports you need to view frequently through "Favorite Reports." You can save a report as a favorite and manage all your favorite reports from any of the report screens using the "Manage Favorites" button. 

Please refer to Managing the Favorite Reports to learn how to manage or export a report. 


    • 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. ...

    • House Account Discount Levels

      House Account Discount Levels Overview These discount levels are also called "Department Level Discounts for House Accounts customers." These are assigned value in the Departments for the discount levels created under the "House Account Discount ...

    • 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 ...