Reports v2: Account Balances

Created by Alex Savchuk, Modified on Fri, Mar 15 at 7:09 PM by Alex Savchuk

The Account Balances Report is intended to provide the ‘Balance information’ for the account. It's a collection of receivable and payable balances for accounts in the City Ledger.

Inputs

ac.png

Effective Date

The predefined options, along with a custom date picker for this field are -

  • Today, (Default Value)
  • Yesterday.

Include Account Type

All available Accounts can be (de)selected using the “select all/clear all” option.

Included Balances

Select the type of balances to be in the report:

  • Receivable balances
  • Payable balances
  • All (Both Receivables and Payables)

Sort Report By

This field has 5 input options, such as -

  • Account Name,
  • Account Number,
  • Advanced Deposit,
  • 1-30 Days Past Due,
  • 31-60 Days Past Due,
  • 61-90 Days Past Due,
  • Over 90 Days Past Due,
  • Total Due.

 

Output

ac1.png

ac2.png

Summary View Section

Displays a summary view of balances for each Account.

Receivables and Payables are marked separately.

Detailed View Section

Displays a detailed view of data per each account type and transaction wise.

The “Sort Report By” option on Input Screen can be used to customize sorting.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article