For accountants
For accountants: clean receipt lists from your clients
By Mumshad Jawad · Updated
Short answer
If your clients hand you shoeboxes of faded receipts, suggest FilsBook: they scan each receipt, check the highlighted fields, and send you one CSV per month with date, supplier, TRN, category, currency, net, VAT, total, whether the VAT was estimated, and a note, plus the original receipts. It is free for them to start, with no account.
What you receive
| 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 |
Amounts are plain numbers with two decimals, the file is UTF-8 with a byte-order mark (Arabic supplier names open correctly in Excel), and text that would run as a spreadsheet formula is neutralised with a leading apostrophe.
What to watch for
- VAT estimated = yes: no VAT line was printed and FilsBook calculated total × 5/105. Treat these rows with care: the supply may be zero-rated, exempt or from an unregistered seller.
- Empty TRN: none was printed, or what was printed was not 15 digits (FilsBook never invents one).
- Other currencies: listed with their own currency code and excluded from the AED totals; no conversion is made.
- Categories are one of 11 fixed labels the client can change: Food & drink, Groceries, Transport & fuel, Office & supplies, Software & subscriptions, Phone & internet, Travel & hotels, Utilities & rent, Professional services, Marketing, Other.
A request you can send clients
"Please scan each business receipt with FilsBook when you get it (mumshadjawad.com/filsbook/app), check any highlighted field, and on the 1st of each month send me the CSV from Export for the previous month together with the original receipts."
What FilsBook is not
It does not file returns, decide what VAT is recoverable, issue tax invoices or submit e-invoices, and it is not approved, certified or endorsed by the Federal Tax Authority. It is a capture-and-organise tool that gives you consistent input; your professional judgement and the rules at tax.gov.ae still apply.
Questions
Can I import the CSV into accounting software?
It is a standard CSV with a fixed header row, so most tools that import CSV can map its columns.
How do I know which VAT figures were printed?
The VAT estimated column says yes for amounts FilsBook calculated as total × 5/105 because the receipt printed only a total, and no for VAT printed on the receipt or worked out from its printed net and total.
Does it cost my clients anything?
Free covers 3 AI scans a day per device without an account; Pro is $5 / 30 days for unlimited scans within a fair-use limit and the PDF report.
Scan your next receipt. Free, no sign-up, and your photos stay on your device.