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

How do I prepare my VAT return every month without gathering invoices by hand?

| Farha Shehata · ERP Implementation Consultant & Trainer

How do I prepare my VAT return every month without gathering invoices by hand?
The short answer

Let the system gather the figures from your posted invoices. In Intagya ERP the VAT return page shows the boxes of the Egyptian or Saudi return in their order, with the value and tax of each box, and a list of invoices to review before filing. You copy the figures to the tax platform, then lock the period in one click so its figures never change afterwards.

Month end in an accountant's office looks the same every time: one Excel file of sales invoices, another for purchases, a supplier bill that arrived late on WhatsApp, and then the manager asks how much VAT is due this month.

Every figure is already in the invoices. The trouble is that a tired person adds them up on the last day.

Why does the VAT return take so much time?

Because it is rebuilt from scratch every month. The accountant exports the invoices, sorts them by tax, adds up taxable, exempt and export sales, then purchases, then subtracts. One wrong filter changes the final figure, and the mistake only shows at review or after it.

It gets worse when invoices change after the return is prepared. Someone edits last month's invoice to fix a price, and the books no longer match what was filed. My view: a return that is not locked after filing is only half a return.

What does the VAT return page in Intagya ERP show?

The boxes of your country's own return form, in their order: box number, description, value and tax. It works for Egypt and Saudi Arabia, by the company country, and takes its figures from posted invoices and credit notes, so refunds are deducted by themselves.

  • It opens on the last finished period, the one you file now, with the due date under the title.
  • Monthly or quarterly: Egypt files monthly; Saudi Arabia starts quarterly and can switch to monthly.
  • Every figure opens the journal items behind it, and from there the invoice.
  • Download Excel gives you a copy to check or send to your auditor.
The VAT return page for Egypt: the return boxes with value and tax, the net tax due, and the Download Excel and Filed, lock the period buttons.
The VAT return page for Egypt: the return boxes with value and tax, the net tax due, and the Download Excel and Filed, lock the period buttons. (Arabic interface, sample data)

How do I find the invoices that would spoil the return before I file?

From the Invoices need review line under the table. It lists the posted customer invoices and vendor bills of the period with a line that has no tax, or a tax that feeds no box of the return.

Example: a new employee issues a service invoice and forgets the tax. In the old way it falls through every filter and quietly leaves the return. Here it shows in the list, and you correct it before filing.

Review that list on the first day of the month, not on filing day. An early fix costs less.

Does the system send the return to the tax authority?

No. The page prepares the figures; you copy them to the return form on the tax authority's platform and file it there. We say it plainly because the difference matters: there is no link to the filing platform, and the accountant files.

If a box shows Not computed, its rule uses a method the page does not compute yet. Work it out from the Tax report before filing.

What happens after I file?

The accounting manager presses Filed, lock the period. The tax lock date becomes the last day of the period, so no invoice with tax dated in it or before it can be posted or changed. The period shows Filed, and the lock is recorded with the name of who did it.

The button does not work before the period ends and only the accounting manager sees it, so nobody locks an open period by mistake.

What if my company is outside Egypt and Saudi Arabia?

Use the Tax report in the same Taxes menu: it shows base and tax from posted entries for every country. The return page with the official form is available today for Egypt and Saudi Arabia only.

Start tomorrow with one step: open the return page on last month, go through the invoices to review, and compare the net with the figure you filed. Any gap will tell you where the mistake was.

FAQ

Does the VAT return page work for Jordan or the UAE?

Not yet. It covers Egypt and Saudi Arabia. For other countries use the Tax report in the Taxes menu.

Does the system file the return for me?

No. The page prepares the figures and an Excel file; you copy them to the tax platform and file there.

What does locking the period mean?

The tax lock date becomes the last day of the period, so no invoice with tax dated in or before it can be posted or changed.

Who can lock a period?

Only the accounting manager, and only after the period has ended.

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