What?
You hand LA Fish the bulk expense template you downloaded from the GİB Defter-Beyan System; LA Fish reads the template's columns and fills them in with your receipts. You upload the filled file to Defter-Beyan yourself — LA Fish doesn't send anything to GİB.
ℹ️ Important: This information is for informational purposes only and does not replace professional accounting advice. Regulations and amounts change, and outcomes vary depending on the taxpayer's specific situation. Consult your certified public accountant (SMMM/YMM) for definitive guidance. LA Fish does not make decisions — it only flags.
This feature is designed for small taxpayers who don't use accounting software: those under the simplified method, business-ledger taxpayers, and self-employed professionals. If you have accounting software, check the Sending to accounting or Exporting page.
At a Glance: Four Steps
| Step | Where It's Done | What Happens |
|---|---|---|
| 1. Download the template | defterbeyan.gov.tr | You download the "… Veri Formatı" (Data Format) (.xlsx) file matching your document type. |
| 2. Prepare your receipts | LA Fish | The receipts you'll export are read and approved; you narrow the scope with a company/date filter. |
| 3. Upload and map the template | LA Fish | Columns are mapped automatically; you pick classification codes that can't be auto-mapped from the template's own list. |
| 4. Fill in and upload to GİB | LA Fish → defterbeyan.gov.tr | You get the filled .xlsx, and you upload it to Defter-Beyan. |
The fields LA Fish maps automatically: Date, Document No., Tax ID/National ID (VKN/TCKN), Merchant, Tax Base, VAT Amount, VAT Rate (converted to the template's code table), Total, and Payment Type (also converted to a code table). What's left for you are the classification codes: things like Tax Office, Expense Record Type / Subtype, Purchase Type.
How?
📥 First, Download the Template from GİB (Common to Both Products)
- Sign In to Defter-Beyan Go to defterbeyan.gov.tr and sign in with your own user credentials.
- Open the Bulk-Add Screen Go to the Toplu Gider Belgesi Ekle (Bulk Expense Document Add) section.
- Download the Data Format Download the … Veri Formatı (… Data Format) .xlsx file matching your document type to your computer. This file is a blank template; it comes with its own code-list sheets built in.
If you get stuck: If LA Fish says "no data sheet found in this file," you've uploaded the wrong file — you need the … Veri Formatı .xlsx, not a guide or a sample PDF. If you opened the file in Excel and re-saved it and the sheets got corrupted, download a clean copy from GİB.
🖥️ Desktop
- Set the Scope Check the receipts you want to export in the receipt list. If you check none, every receipt currently showing in the list (i.e., that passes your filter) is taken — for filtering, see Search and filter.
- Open Defter-Beyan Press the 📋 Defter-Beyan button on the top action bar. The Defter-Beyan (GİB) — Export to Template window opens and shows how many receipts it will fill in.
- Choose the Template Point it to the file you downloaded with the 📂 Select GİB Template (.xlsx) button. LA Fish finds the data sheet, shows the number of columns, and lists what it mapped under ✓ Automatically mapped fields.
- Choose the Codes Columns that couldn't be mapped appear under Classification codes — choose from the template's list or type your own code. You pick a code from the dropdown for each one; if yours isn't listed, you can type your own.
- Fill In and Save Press 💾 Fill and Save, and choose where to save the file from the Save Filled Template window. A file name starting with DefterBeyan_ is suggested.
- Upload to GİB In Defter-Beyan, upload this file via Toplu Gider Belgesi Ekle → Excel Göster (Bulk Expense Document Add → Show Excel).
🌐 Web Panel
- Set the Scope First, set the company selection, search, and date range on the My Receipts screen. The receipts that get filled in are taken based on the company and filter you set here — if you work with more than one taxpayer, see Company / taxpayer separation.
- Go to the Accounting Section Open the Accounting panel from the left menu; the Defter-Beyan (GİB) — Export to Template card is here.
- Upload and Parse the Template Choose the .xlsx you downloaded from the file picker, then press Parse Template. The screen shows which data sheet was found and which fields were mapped automatically.
- Choose the Codes Enter classification codes into the fields that appear below. Clicking a box opens the template's own list; or you can type your own code directly into the Choose from list or type a code field.
- Fill In and Download Press Fill and Download; the filled file comes down as lafish_defterbeyan.xlsx.
- Upload to GİB In Defter-Beyan, upload the file via Toplu Gider Belgesi Ekle → Excel Göster (Bulk Expense Document Add → Show Excel).
📱 Mobile
Preparing Defter-Beyan isn't available on mobile. The app tells you this outright: this job is done on the web panel and desktop. Your phone's job is capturing the receipt; the moment it lands in the cloud archive, you open the web panel with the same account and finish the export from there — see Cloud archive and multi-device.
If you get stuck: If you get a "No receipts to export" warning, either no receipts have been added at all, or your filter is narrow enough to exclude everything. Clear the filter first, confirm receipts show up in the list, then try again. If a receipt's fields come out empty, it probably hasn't been approved — Reading and approval.
My uploaded template isn't accepted — what should I check?
- Is the file extension .xlsx? The older .xls or .csv won't work.
- Was the file downloaded directly from GİB? You need the actual template, not a "similar" table exported from another program; code lists are read from separate sheets inside the template.
- An unexpectedly large or complex file is rejected. GİB's data format file is small; if you've bloated it by manually adding your own data, try again with a clean copy.
- If you opened the template in Excel and renamed the sheets or deleted the code sheets, the mapping breaks. Download it again from GİB.
Why This Way?
Why aren't the codes built into the software? Because the GİB template changes: new document types get added, code lists get updated, versions get refreshed. LA Fish reads the column headers and code tables straight from the template you upload at that moment. That way, whatever version GİB issues, the export keeps working — you don't have to wait for an update.
Why doesn't LA Fish send the file to GİB? Because the filing is your responsibility. LA Fish doesn't connect to your Defter-Beyan account, doesn't enter credentials there, and doesn't create entries on your behalf. What it does is hand you a correctly prepared file; reviewing and uploading it is on you. This also prevents a wrong bulk entry from slipping into the system unnoticed.
Why do I choose some codes by hand? Fields like Tax Office and Expense Record Type aren't written on the receipt — they depend on your specific tax liability and how you classify the expense. Instead of guessing, LA Fish puts the template's own list in front of you; you make the call.
If you get stuck: Open and check the file once before uploading it to GİB. Check especially the code equivalents for the VAT rate and payment type, and the classification codes you chose by hand. If you keep getting error messages, see the Troubleshooting page.
This feature is available on paid plans; you can see what's included in which plan on the Pricing page.
Related Pages
Exporting
If you need an Excel/CSV file instead of Defter-Beyan, or you're handing it to another program, start here.
Sending to Accounting
If you have accounting software, the direct-submission route without dealing with a file.
Search & Filter
Your filter is what determines which receipts get exported; set the scope correctly first.
Company & Taxpayer Separation
Don't let multiple taxpayers' receipts mix; choose the right company before exporting.
Last updated: 2026-09-09