The VAT Ledger is a report that displays all VAT-related transactions within a selected date range. It shows details such as transaction type, contact, VAT profile, currency, net amount, VAT amount, and gross amount.
Go to Reports > VAT Ledger.
Click on the Date Range dropdown. You may select preset options such as This Month, This Financial Quarter, This Financial Year, Last Month, Last Financial Quarter, or Last Financial Year.
You may also manually select a custom start and end date.
Yes. Click on Group By and choose from:
None
VAT Profile
VAT Type
Yes. Click on Filter and apply filters based on available fields such as:
Account Name
Account Type
Contact
Currency
VAT Profile
VAT Type
Transaction Type
Transaction Reference
VAT Rate (%)
Net (base currency)
VAT (base currency)
Click Apply to activate the selected filters.
Yes. Click the settings icon and choose Adjust Columns. You may select, remove, or rearrange columns such as:
Account Code
Account Name
Account Type
Tracking Tags
VAT (base currency)
VAT Adj. (base currency)
Net (Source)
VAT (Source)
Gross (Source)
VAT Adj. (Source)
VAT Type
VAT Rate (%)
Contact Tax ID
FX Rate: Source to Tax
Contact
VAT Profile
Currency
Net (base currency)
Gross (base currency)
Click Save after making changes.
Display Options allows you to control what additional information appears in your VAT Ledger report and exported file. You can enable:
Print exchange rates: includes the exchange rates used for foreign currency transactions in the downloaded report.
Print report notes: includes any report notes entered in the VAT Ledger in the downloaded report.
Yes. You can select an existing template such as Standard VAT Ledger.
You may also click Add New Template to create a customized VAT Ledger layout.
Yes. Click the download icon to export the VAT Ledger based on your selected date range, filters, grouping, and column settings.
The VAT Ledger includes VAT-applicable transactions such as invoices and bills that use VAT profiles.
Yes. If your organization uses multi-currency, the VAT Ledger can display amounts in both the source currency and the tax currency, depending on the columns selected in the report.
Note: The tax currency is always the organization’s base currency, which is defined during organization creation.
Base Currency
The base currency is the organization’s default currency configured during organization creation. This also serves as the tax currency used in the VAT Ledger.
If a transaction is recorded in a different currency, the VAT Ledger automatically converts the transaction amounts into the base currency for reporting and tax computation purposes.
Source Currency
The source currency refers to the original currency in which the transaction was recorded.
For example, fields such as Net (Source), VAT (Source), and Gross (Source) display the original transaction amounts before conversion into the base currency.
