Overdraft account example

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

The Financial Reporter module enables you to use conditional expressions in your financial statement worksheet to set up an overdraft account. This allows you to display an balance sheet account as either a Current Asset or a Current Liability based on a debit or credit balance. On a month-to-month basis you can see the changes in the account reflected in the correct section of the statement without having to make any sign changes based on a debit or credit balance.

Conditional expression for assets section

The example below illustrates a conditional expression where the Cash amount (row 7) prints if the value is greater than zero. If the condition is met, the application prints rows 7-10. If the condition is not met (cash less than zero), the application will print the ELSEIF rows (12-14), which do not include the negative cash amount.

The following screen illustrates how the Conditional Expression is set up for the Current Asset section of the sample statement:

Conditional expression for liabilities section

A conditional expression is also set up in the Liability section of this sample worksheet. Here the print condition changes to: Print IF Cash is less than zero (opposite to the condition set up for the Assets section of the balance sheet). See example.

As in the Assets section of the balance sheet, use row summing to calculate the correct Total Liabilities for the Liabilities section.

The following screen illustrates how the Conditional Expression is set up for the Current Liability section of the sample statement:

See also: Summing formulas

Share This