White Friday: up to 30% off your subscription 0days 0hrs 0min
Intagya
Pricing Blog Try free
← All articles

How do I get exactly the financial report I need without exporting it to Excel?

| Ziad Washah · Chief Financial Officer

How do I get exactly the financial report I need without exporting it to Excel?
The short answer

Pick the report from the list and narrow it with filters instead of copying and sorting it. In Intagya ERP every report is on one screen: income statement, balance sheet, trial balance, ledger, statement of account and more. Each has filters by account, customer or vendor, period, journal, cost centre and branch, and you save what you picked as a favourite report that opens in one click.

The manager asks for the maintenance account of the Alexandria branch in the third quarter. The accountant exports the whole ledger to Excel, deletes the other accounts, sorts by date, then finds the branch is not a column in the file. An hour later a table goes out, and the next question starts the cycle again.

The report existed. What was missing was the filter.

Why do financial reports take longer than they should?

Because most systems give you the whole report and leave the filtering to you. You export, delete and sort in Excel, and every time the question changes you redo it. When the same question comes every month, you redo the same work every month.

Where do I find the reports in Intagya ERP?

On one screen. From the Reporting menu of Finance open All financial reports, and a list sits at the side of the screen:

  • Financial statements: income statement, balance sheet, cash flow.
  • Books: trial balance, ledger, day book, journals audit, bank and cash book.
  • Customers and vendors: statement of account, aged balances.
  • Taxes and budget: tax report, VAT return, budget vs actual.

Press a report name and it shows; the period and branch stay as you picked them when you move to another one.

The financial reports screen: the side list with favourites at the top, and the income statement with the filter bar above it.
The financial reports screen: the side list with favourites at the top, and the income statement with the filter bar above it. (Arabic interface, sample data)

How do I narrow a report to one account, customer or branch?

From the filter bar above the report. Each report has the filters that suit it: account or account group, customer or vendor, period, journal, cost centre, and branch when your company has branches. Search by name or number and pick; every choice shows as a small chip under the bar that you remove alone, or press Clear all.

The Options button holds what belongs to that report: Hide accounts without movement on the trial balance, Percent of revenue on the income statement, By due date on aged balances, Open items only on the statement of account.

How do I compare this year with the one before?

From Period. Pick the period, then the comparison: same period last year, the last 3 periods, or a column for each month on the income statement. A column per month helps more than it seems: one row shows you when an expense jumped.

My view: in most businesses, last year is a fairer comparison than last month, because seasons repeat. The back-to-school month does not compare with the month before it.

Can I send the statement of account to the customer straight away?

Yes. Open Statement of account and pick the customer: you see the opening balance and every movement after it. With one customer picked, a Send on WhatsApp button shows. PDF and Excel are there too.

Statement of account for one customer: filters and chips above the report, and Send on WhatsApp next to Excel and PDF.
Statement of account for one customer: filters and chips above the report, and Send on WhatsApp next to Excel and PDF. (Arabic interface, sample data)

How do I avoid picking the same filters every month?

Save them. Save as a favourite report keeps the report with its filters under a name you choose, such as Monthly trial balance or Alexandria branch expenses, in Favourites at the top of the list, for you only. Next month you just press it.

Save the reports your manager asks for every month under the words of his questions. When he asks, you open a favourite instead of searching.

Every figure in any report opens the journal items behind it, and from there the invoice itself. Try one thing tomorrow: open the income statement, pick a column for each month, find the biggest jump and press it.

FAQ

How many reports are on the financial reports screen?

Thirteen: income statement, balance sheet, cash flow, trial balance, ledger, day book, journals audit, bank book, cash book, statement of account, aged receivable, aged payable and tax report. The VAT return and budget vs actual sit in the same list.

Do my colleagues see my favourite reports?

No. A favourite report is saved for the user who saved it only.

Can I download the report after filtering?

Yes, Excel and PDF carry the report as you see it, with its filters.

Can I see a report for one branch?

Yes, from the Branch filter when your company has branches.

Want to see IntagyaERP on your own workflow?

Book a demo, tell us how your business runs, and watch the system handle a real scenario from your company.

Book a demo