Bought Pro? It is on your mumshadjawad.com account. Sign in
FilsBook

Guide

A monthly expense report your accountant can use

By · 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

  1. Check the month

    Open the receipts list and fix anything highlighted. Estimated VAT is fine to keep, it is marked in the export.

  2. Open Export

    Choose the month. FilsBook shows the receipt count, net, VAT and total for it.

  3. Download the CSV

    In the web app press Download CSV. The file is named like filsbook-2026-10.csv and is made on your device.

  4. 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.

  5. 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

ColumnExampleWhat it holds
Date2026-10-12Purchase date, YYYY-MM-DD, so it sorts correctly in any spreadsheet
MerchantSample Café Saffron LaneSupplier name as on the receipt (English when both are printed)
TRN100000000000003Supplier’s 15-digit Tax Registration Number; empty when none was printed
CategoryFood & drinkOne of 11 fixed categories
CurrencyAED3-letter currency code
Net45.00Amount before VAT
VAT2.25VAT as printed, or estimated
Total47.25Amount paid
VAT estimatednoyes when no VAT was printed and FilsBook calculated total × 5/105
NoteClient meetingYour 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:

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:

CategoryReceiptsVAT (AED)Total (AED)
Marketing125.00525.00
Phone & internet119.00399.00
Office & supplies111.00231.00
Transport & fuel28.97188.50
Groceries18.90186.90
Software & subscriptions13.5073.50
Food & drink12.2547.25
All (8 receipts, 2 with estimated VAT)78.621,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.

Open FilsBookHow FilsBook works