Account Summary Report

Account Summary Report

What is the Account Summary Report?

The Account Summary report is a report used to display the net movement of a specific accounting account monthly during a time period you choose within the current fiscal year only.

In other words:

• The report does not display invoice or journal entry details.

• It does not show the opening balance.

• It does not show the closing balance.

• It displays only one number per month that shows:
  how much the value of this account increased or decreased during this month.

When do I use the Account Summary Report?

Use the Account Summary report if your question is something like:

• What was the bank account movement in month 6?

• Did this account increase or decrease this month?

• I want to quickly compare account movement from month to month.

• I want a quick overview without getting into journal entry details.

• Know how much the account value increased or decreased during each month

• Track account movement (bank, cash, revenue, expense…) quickly

• Compare account performance between months without getting into details

• Get a brief analytical overview with a chart

Do not use it if you want:

• Knowledge of transaction details.

• Know where the number came from.

• Review invoices or documents.
  In this case use the Account Statement Report.

Where do I open the Account Summary Report?

From the main menu in the system:

• Reports

• Account Summary

Filter Options in the Account Summary Report

1️⃣ Account Name

• Select only one account from the chart of accounts.

• The report supports all account types (bank, cash, expense, revenue, assets, liabilities…).

2️⃣ Time Period

• You select month to month.

• The report works only on the current fiscal year.

• You cannot extract an account summary for a previous year from this report.

Very Important Note
If you need data from previous years → use Account Statement not Account Summary.

What data does the report display?

First: Monthly Table

It displays:

• The name of each month within the selected period.

• For each month: the net movement of the account during that month only.

The displayed number:

• Is not the balance.

• Does not include the opening balance.

• Does not represent what “remains” in the account.

• Represents only the movement that occurred within this month.

How is Net Movement Calculated?

Net movement is calculated according to the account nature:

• If the account is debit in nature:

  • Increase = positive number

  • Decrease = negative number

• If the account is credit in nature:

  • Increase = positive number

  • Decrease = negative number

Illustrative Example
Cash Account:

• In month 5, 1,000 SAR was spent more than what came in.

• It will appear in the account summary:

  • -1,000

This does not mean the cash account is “negative” in reality,
but rather that the month’s movement was a net cash outflow.

Second: Chart

• The chart displays the same numbers as the table.

• It represents the net movement for each month.

• It displays:

  • Positive values.

  • Negative values.

• The chart is monthly only.

Any difference between the chart and the table?
None
Both rely on exactly the same data.

What happens when you click on a month amount?

When you click on the amount shown for any month:

• You are automatically directed to the Account Statement Report.

• For the same account.

• And for the same month.

• Starting from the first day of the month.

• And ending on the last day of the month.

And in the Account Statement:

• You will see the opening balance.

• And all detailed transactions.

• And you will understand exactly:
  where the net movement number shown in the account summary came from.

Do closing entries appear in the Account Summary Report?

Yes.

In case:

• Closing the fiscal year using the fiscal years feature.

Then:

• Revenue and expense closing entries.

• And the entry transferring net profit or loss to the equity account.

Will appear:

• Within the movement of the last month of the fiscal year.

• And on the last day of that month.

This is correct and normal behavior.

Is the Account Summary Report affected by allocation?

No
The report is affected only by journal entries.

• Allocation does not change the numbers.

• Any change in the numbers is caused by:

  • Creating an entry

  • Deleting an entry

  • Approving a document

Does the report include tax?

No
Account Summary displays the account value only.

• Value Added Tax (VAT):

  • Can be reviewed from the Tax Account Statement.

  • Or from Tax Reports.

What if the report doesn’t appear or appears empty?

Check the following in order:

1️⃣ Did you select the correct account?
2️⃣ Is the period within the current fiscal year?
3️⃣ Is there actual movement on the account during these months?
4️⃣ Do you have permission for the report?

Required Permissions

To use the report, the user must have permission for:

• Account Summary Report

Through:

• Settings

• Users

• Manage Roles

• Edit Role

• Enable Account Summary Report Permission

Summary of the Difference Between Account Summary and Account Statement

• Account Summary:

  • One number per month

  • Quick overview

  • Without details

  • Without opening balance

  • For the current year only

• Account Statement:

  • Detailed report

  • Shows all transactions

  • Includes opening balance

  • Works for any year