The account ledgers are another representation of the journal, broken down by account. Various filter and export options are available in the account ledgers.
Content
What filter options do I have?
Account
You must enter at least one account to get a result. If both accounts are filled in, these two accounts and all those in between will be displayed.
Date
To see a result, you must always specify a date range. By default, the date range is your current fiscal year. However, larger or smaller ranges can also be specified.
Tip: To be as fast as possible, enter the desired date using the keyboard; the following format is sufficient: 01012026. bexio will then automatically insert the dots. To get to the next field, it is best to use the Tab key.
Amount
With the amount filter, you can either search for exact amounts by entering the same amount in both fields. You can also search for amounts within a range. You can only search for amounts in the base currency of your bexio account.
VAT
The VAT rate and VAT number fields offer maximum transparency when creating tax returns: While you can search for specific percentages or tax-free bookings using the tax rate, the VAT number allows a direct link to the tax form. Simply select the desired numbers, and the system will instantly present all relevant bookings hidden behind them.
Booking type
Every booking created in bexio has a booking type. If you are looking for a booking from an invoice, for example, you can specify the booking type Invoice (IN).
Reference number
You can search for entire reference numbers, for example IN-198058, or if you want to search for the booking with reference 1, in this case, simply enter 1 in the reference number field. Then all bookings with reference 1 will appear.
Search for 1
All bookings that have exactly "1" as a reference will appear (1, 000001, IN-2019-00001 etc.)
The following will not (123512, 1000, 000017, 111 etc.).
Search for 1596
All bookings that have exactly "1596" as a reference will appear (1596, 001596, IN-01596 etc.)
The following will not (191596, 015960 etc.).
It is not possible to filter by a special character alone; the special character must be combined with a letter or a number.
Description
The filter by description gives you all bookings that contain the word you entered.
Search for "pay"
All bookings in which the booking text "pay" is contained will appear (Payment, Payment received, Overpayment etc.)
It is not possible to filter by a special character alone; the special character must be combined with a letter or a number.
What list options do I have?
Show/hide balance brought forward/carried forward
You have the option to hide balance brought forward and carried forward entries, depending on whether you need them. Balance brought forward entries are opening bookings that you either provisionally executed or that were created by the annual closing. Carried forward entries are not bookings, but rather calculations of the balance from the previous period that are then transferred to the next period.
Once the 'Show carry over' checkbox is selected, no other column sorting options are available..
Hide 0-value bookings
You can hide bookings with the "Hide 0-value bookings" option to shorten your report.
Show accounts with movements only
If you activate "Show accounts with movements only", only accounts with bookings will be displayed in the account search area. Otherwise, accounts without bookings will also be displayed.
Sorting columns
All columns, except for the balance column, are sortable. To do this, click on the column header; the arrow indicates whether the list is sorted in ascending or descending order.
As long as the "Show carry over" option is activated, it is not possible to display the bookings in any other order than "oldest booking at the top".
What export options do I have?
At the center of the export is your current view: In principle, exactly what you have previously defined through your filters will be output. This flexibility accompanies you through all formats – so you decide individually for both Excel and PDF files whether you want to export only the filtered selection or the entire account balance.
Depending on the chosen medium, however, there are subtle differences in the presentation: While the Excel export generally transfers the numbers with all available decimal places, the focus of the PDF is on aesthetics. Here you choose between portrait and landscape format. Please note that in the compact portrait format, the foreign currency columns are omitted for readability.