Statement of Account

Owned by Van Ho (Deactivated)
Last updated: Apr 10, 2018 by Diane Partridge

Overview

Statement of account is a summary of financial transactions which have occurred over a given period, the report available provides the debit, credit and balances also showing account balance by days are visible on the report. 

Rule

Rules: Ensure the following setups are done on each customer card before you run any type of statement run

  • Customer Card must have a status of Active or On Stop
  • Customer card>Settings>Customer Settings>Statement method must be set to PRINT

Image of report result

 Show me

Running the report

  1. In the Navigation panel, go to Reports> Form Reports.
  2. In the list of reports find the category Relationships>Statement of Account 

  3. Select a parameter some options may be as per image

     Show me

  4. Click on Show Report Using Parameters, screen as per below will appear

     Show me

    If a customers card is set to have a statement delivery method = none, then when you run the statement of accounts, you can specify whether or not you want to print that statement or not.

  5. Enter the Statement Date.
  6. Start Customer and End Customer fields
    1. If you require all customers leave both fields blank 
    2. If you require 1 customer key in same card id into both fields
    3. If you require specific range of customers based on card id enter start customer and end customer for that range. 
    4. f you dont want to print statements with zero balance then ensure the flag is ON for 'Skip Zero Balances'
    5. If you dont want to print statments that are in Credit balance then ensure the flag is ON for 'Skip Credit Balances'
    6. If the Customers Cards have been set to Email Statement then ensure that the 'Skip Auto email Statements' flag is ON.
    7. If the Customers Cards have been set to 'Skip Delivery Method None' and you dont wish to print these then turn this check box ON.
    1. Click on OK to extract the statements.
    2. Statement will appear to screen. Check a few then Print
    3. Print the statements that are not set to email by clicking on the Print Icon
    4. Close Out Once done.
  7.  Show me

  8. Adding Bank Account Details

    If you require your bank account details to appear on your statement you will need to go to Financials > General Ledger> Accounts> List View locate the bank account and go to the settings tab and flag it as "Primary Bank Account".

Skipping statements for customers with a statement delivery method on none

The Statement of account report, being report "F-021" , has an option on it's report parameters to skip printing of statements for customers with a statement delivery method of none.



Use Case

  • Require to print statement for a specific, range or all customers