A VAT return deadline is a poor time to discover that three supplier invoices are missing, a credit note was posted twice, or a dollar invoice was converted using the wrong rate. That is why knowing how to prepare VAT summaries is less about filling in a form and more about building a dependable monthly process.
For Maltese businesses, a useful VAT summary brings sales, purchases, VAT treatment and supporting records into one reviewable view. It gives the business owner clarity before filing and gives the accountant figures worth checking rather than rebuilding from scratch.
How to prepare VAT summaries step by step
A VAT summary should answer four practical questions: what did the business sell, what did it buy, which transactions carry VAT, and what VAT is due or recoverable for the period? The figures matter, but so does the trail behind them.
Start with the correct reporting period. Use the same cut-off date across sales invoices, purchase invoices, credit notes and expense claims. If an invoice belongs to the period but arrives late, record it according to the VAT accounting treatment that applies to your business and flag it for review. Do not simply add it to whichever month you happen to be processing.
The goal is simple: every total in the summary should be traceable to a document, and every document should have a clear VAT treatment.
1. Gather every sales document
Your sales side should include issued invoices, receipts where relevant, credit notes and any self-billed documents. Check that invoice numbering is complete and that cancelled invoices have not disappeared without an audit trail.
Separate the net value from VAT and gross value for each sale. Then identify the treatment: standard-rated, reduced-rated, zero-rated, exempt, outside the scope, or another treatment relevant to the transaction. The correct category depends on what you sell, where the customer belongs, and whether the supply is goods or services.
A local invoice and a cross-border EU transaction may look similar on paper but require different treatment. That distinction affects both the VAT due and how the transaction is reflected in your Malta VAT return figures. Never categorise a sale based on the supplier or customer name alone.
2. Capture purchases before chasing totals
The purchase side is where many VAT summaries become unreliable. Supplier invoices arrive through email, WhatsApp, staff expense claims and paper receipts. If they are gathered only at month end, missing documents are almost guaranteed.
Capture invoices as they arrive. For each document, retain the supplier name, invoice date, invoice number, net amount, VAT amount, gross amount, currency and VAT category. Keep the original image or PDF with the extracted data. A spreadsheet total without the invoice behind it is not a useful accounting record.
Review whether input VAT is recoverable before including it in your claim. Some costs may have restrictions, may relate to exempt activity, or may not contain deductible Maltese VAT at all. A supplier charging an amount labelled as VAT does not automatically make that amount recoverable.
This is also the point to identify reverse-charge and EU purchase scenarios. These can require VAT to be accounted for on the return even where the supplier invoice does not show Maltese VAT. The detail depends on the nature of the supply and the status of both parties, so unusual or high-value transactions deserve accountant review.
3. Treat credit notes as part of the period
Credit notes are not an afterthought. They reduce the original sale or purchase and may alter the VAT position for the reporting period.
Match every credit note to the original invoice where possible. Confirm whether it relates to a full cancellation, a returned item, a price adjustment or an earlier-period correction. Recording the gross amount as an expense or income adjustment without the VAT split is a common error that distorts the summary.
A clean process shows original invoices and credit notes separately, then presents the net position. That makes the report easier to review and far easier to explain if a figure is queried later.
4. Convert foreign-currency invoices consistently
Foreign currency adds an extra layer of risk. The invoice may be in pounds, dollars or another currency, while the VAT records and return are prepared in euros. The conversion method needs to be consistent and supported by the rate used.
Record the original currency amount as well as the euro value. Apply the appropriate exchange rate for the relevant date and retain the basis for the conversion. Do not use the bank payment amount as a shortcut for the invoice value. Payment date differences, bank charges and exchange gains or losses can make those figures different.
For a handful of invoices, this can be handled carefully by hand. For a growing business, it becomes a repetitive control task. Automatic currency conversion reduces the arithmetic, but the underlying VAT category still needs to be right.
Turn transaction data into a VAT-ready summary
Once records are complete, group the transactions by VAT treatment rather than looking only at one grand total. Your summary should clearly show sales and purchases by category, the related output VAT and input VAT, and adjustments such as credit notes or reverse-charge entries.
For each category, compare the net amount, VAT amount and gross amount. The basic arithmetic should hold: net value plus VAT equals gross value. Small rounding differences can occur, but unexplained gaps usually point to a duplicated document, a missing VAT amount or a value entered in the wrong column.
The layout should also map cleanly to the figures required for the Malta CFR VAT return. That does not mean a report can replace judgement. It means the report should make the return preparation faster, with each pre-filled figure supported by transactions that can be opened and checked.
A practical monthly VAT summary usually contains:
- total sales, split by VAT treatment;
- total purchases and recoverable input VAT, split by treatment;
- output VAT due on sales and VAT accounted for under reverse-charge rules where applicable;
- credit notes, adjustments and prior-period corrections; and
- the resulting VAT payable or refundable position.
Keep exempt, zero-rated and outside-the-scope transactions separate. They may all result in no VAT being charged, but they are not interchangeable categories. Combining them because the VAT column is zero creates problems later.
Reconcile before you file
A VAT summary is ready for review only after reconciliation. Start with sales. Compare the sales total in the summary with your invoicing system, payment records and, where useful, bank receipts. The figures will not always match exactly because customers pay late, pay deposits or settle several invoices at once. The purpose is to explain the difference, not force an artificial match.
Then reconcile purchases against supplier statements, payment runs and the documents captured during the period. Look for repeated invoice numbers, unusually round VAT amounts, invoices dated outside the period and expenses posted without a receipt.
Finally, compare the VAT control balance with the previous period. A sharp change is not necessarily wrong. It may reflect a large equipment purchase, a seasonal sales peak or a credit note. But it should have a reason. If nobody can explain the change in one sentence, investigate before filing.
Build a process that does not depend on spreadsheets
Spreadsheets can work for a small number of transactions, but they become fragile when invoice volumes rise. Version confusion, manual copy-and-paste, missing attachments and inconsistent formulas all increase the chance of filing from incomplete data.
A better workflow captures documents continuously, extracts the key fields, assigns the VAT category, converts foreign currency where needed, and produces a monthly exception list. Your team then reviews the transactions that genuinely need judgement instead of retyping every routine invoice.
MyAccountant is designed around that workflow for Malta-based businesses. Invoices can be submitted by email, WhatsApp or dashboard upload, then processed into audit-ready records and monthly summaries with pre-filled Malta CFR VAT return figures. The value is not another place to store PDFs. It is less manual admin and a clearer review point before the return is filed.
Automation does not remove accountability. Someone still needs to check unfamiliar suppliers, unusual VAT treatment, large adjustments and incomplete invoices. But it removes the low-value work that makes those checks harder than they need to be.
A better monthly rhythm
Do not leave VAT preparation until the final days of the reporting period. Set a short monthly close: capture outstanding documents, review exceptions, reconcile key totals and approve the summary. The exact timing depends on transaction volume and whether an accountant manages the filing, but the habit matters more than the calendar.
A VAT summary should make month end quieter, not more complicated. When every invoice is captured early and every exception has an owner, filing becomes a final review of organised records rather than a last-minute search through inboxes, chats and spreadsheets.