Chart of accounts, VAT codes, allocation keys and ledgers
Updated:
The master data of the internal ledger: accounts, VAT codes, automatic cost allocation and parallel books.
Open General ledger in FiattoIn this article
Under Accounting → General ledger → Setup you set up the master data of the ledger: the Chart of accounts, the VAT codes, the Allocation keys and the Ledgers (parallel books). Approvers and accountants open these pages; creating or archiving ledgers is admin work.
Steps
- Chart of accounts (
/dashboard/grootboek/rekeningschema): if you have no chart yet, click Create RGS starter template (for a Belgian company Create MAR starter chart (Belgium)) or use Import chart of accounts with a CSV. You first see per row whether an account will be created, updated or left unchanged. Export CSV downloads the chart. - Open an account via Edit account for name, RGS link, Cash flow category, Postable, Control account (refuses manual entries) and Suspense account, and for the Default VAT code and Default cost centre that the posting screen prefills. Per account you also set the attachment requirement, a required cost centre and Required dimensions.
- VAT codes (
/dashboard/grootboek/btw-codes): click Set up the Dutch standard codes or create a New code with Rate, Type (purchase or sales), VAT reverse charged, Base amount box and VAT amount box. Once a code has been used in entries, its rate, type and boxes are fixed; withdraw the code and create a new one instead. - Allocation keys (
/dashboard/grootboek/verdeelsleutels): distribute costs that arrive without a cost centre, such as rent, energy or licences, automatically across cost centres and projects. Create a New key with a Source account and choose Fixed weights or Driver (statistical account); with a driver, the balance of a statistical account per cost centre (for example headcount or m²) determines the weight. - Ledgers (
/dashboard/grootboek/boeken): run parallel books next to the primary (IFRS) ledger, such as ASC 842 or NL tax. An admin adds a book under Add a secondary ledger (code, name, Framework, currency) and clicks Create book.
Tips
- The allocation is posted automatically on the first of the month for the month just closed, after deferrals and depreciation; running it again never posts twice.
- A VAT code on a general journal or cash line only records data; the VAT return is calculated from your sales and purchase invoices.
- Statements, journal and period reporting can be shown per book. See also Daybooks, dimensions and posting authority and Working with the internal ledger.