Guide
A monthly expense report your accountant can use
By Mumshad Jawad · Updated
Short answer
Accountants want the same columns every month: date, supplier, TRN, category, currency, net, VAT, total and whether the VAT was printed or estimated. FilsBook's CSV export has exactly those 10 columns, opens in Excel and Google Sheets (Arabic names included), and is free. With Pro you can also save a printable PDF report with totals by category.
Step by step
Check the month
Open the receipts list and fix anything highlighted. Estimated VAT is fine to keep, it is marked in the export.
Open Export
Choose the month. FilsBook shows the receipt count, net, VAT and total for it.
Download the CSV
In the web app press Download CSV. The file is named like
filsbook-2026-10.csvand is made on your device.Add the PDF (Pro)
With Pro, Download PDF in the web app gives an A4 report: the totals, every receipt in the report currency (AED), and totals by category.
Send it with the receipts
Email both files to your accountant, together with the original receipts or your copies of them.
The columns, one by one
| Column | Example | What it holds |
|---|---|---|
| Date | 2026-10-12 | Purchase date, YYYY-MM-DD, so it sorts correctly in any spreadsheet |
| Merchant | Sample Café Saffron Lane | Supplier name as on the receipt (English when both are printed) |
| TRN | 100000000000003 | Supplier’s 15-digit Tax Registration Number; empty when none was printed |
| Category | Food & drink | One of 11 fixed categories |
| Currency | AED | 3-letter currency code |
| Net | 45.00 | Amount before VAT |
| VAT | 2.25 | VAT as printed, or estimated |
| Total | 47.25 | Amount paid |
| VAT estimated | no | yes when no VAT was printed and FilsBook calculated total × 5/105 |
| Note | Client meeting | Your own note, if any |
A real sample
These lines were produced at build time by FilsBook's own export code from its labelled sample receipts (fictional merchants):
Date,Merchant,TRN,Category,Currency,Net,VAT,Total,VAT estimated,Note
2026-10-02,Sample Café Saffron Lane,100000000000003,Food & drink,AED,45.00,2.25,47.25,no,Sample receipt
2026-10-03,Sample Fuel Station,100000000000011,Transport & fuel,AED,142.86,7.14,150.00,no,Sample receipt
2026-10-05,Sample Stationery House,100000000000029,Office & supplies,AED,220.00,11.00,231.00,no,Sample receipt
2026-10-06,Sample Cloud Software,,Software & subscriptions,AED,70.00,3.50,73.50,yes,Sample receipt
Details that save your accountant time:
- UTF-8 with a byte-order mark, so Excel shows Arabic merchant names correctly instead of garbled characters.
- Plain numbers such as
1234.50, with no thousands separators or currency signs, so they sum straight away. - Formula-safe: text that a spreadsheet would run as a formula (starting with =, +, - or @) gets a leading apostrophe.
- VAT estimated says
yeswherever the VAT was calculated as total × 5/105 because none was printed.
The monthly summary
The summary in the app and the PDF report adds up one currency (AED by default). Receipts in other currencies are listed in the CSV with their own currency but left out of the totals, and the report says how many there were; FilsBook does not convert currencies. For the same sample month the summary looks like this:
| Category | Receipts | VAT (AED) | Total (AED) |
|---|---|---|---|
| Marketing | 1 | 25.00 | 525.00 |
| Phone & internet | 1 | 19.00 | 399.00 |
| Office & supplies | 1 | 11.00 | 231.00 |
| Transport & fuel | 2 | 8.97 | 188.50 |
| Groceries | 1 | 8.90 | 186.90 |
| Software & subscriptions | 1 | 3.50 | 73.50 |
| Food & drink | 1 | 2.25 | 47.25 |
| All (8 receipts, 2 with estimated VAT) | 78.62 | 1,651.15 |
This guide explains how FilsBook works and a few well-established basics. It is not tax advice: for the rules that apply to you, ask your accountant or check the Federal Tax Authority at tax.gov.ae.
Questions
Can I open the CSV in Excel?
Yes. It is UTF-8 with a byte-order mark, so Excel and Google Sheets open it with Arabic names intact.
Is the CSV export free?
Yes. The CSV is free. The printable PDF report is part of Pro.
How does my accountant know which VAT amounts were estimated?
The CSV has a VAT estimated column (yes or no), and the PDF report marks estimated VAT with an asterisk and a note.
What about receipts in US dollars?
They stay in the CSV with their own currency, but the AED totals leave them out. FilsBook does not convert currencies.
Scan your next receipt. Free, no sign-up, and your photos stay on your device.