Under
Accounts payable/Reports/Account statements , you can print account statements with transactions for one or more customers.
Bank statements can also be printed using the
Bank statement button on the ribbon in the vendor register under
Vendor/Creditor. If the account statement is created from the accounts payable register, a filter is automatically applied to the selected vendor when the
Account statement button is selected.
Fill in the delimiter fields and select the
Search button to generate a list of customers that the system recommends you create a bank statement for.
Description buttons on the ribbon
| Button |
Button description |
| Search button |
Select the Search button to generate a list of customers that match the values specified in the delimiter fields and those defined in the Filter Creditors button. |
| Filter creditors |
Using this button, filters can be added to the values in the creditors list.
Example:
For example, if you only want to generate bank statements for creditors that are not blocked, you can create this filter
Blocked is a yes/no field. No/no checkmark = 0 and Yes/checkmark = 1.
I.e. if you only want to print bank statements for those who are blocked, you would simply replace the 0 in Filter by with a 1 instead.
 |
| Clear filter |
If you have created filters that you want to reset, you can select the Clear filter button. |
| Physical voucher |
Select the Physical voucher button or press F7 to, for example, display the invoice to the customer if you have placed the cursor on a line under a vendor with an invoice posted in Uniconta.
If necessary, use the Expand row button to expand the entries for a customer in the overview. |
| Entries on vouchers |
Select this button if you want to see the financial entries that have been posted on the entry you have placed the cursor on. |
| Open items |
Select this button if you want to see open vendor records on the vendor you have placed the cursor on. This is useful, for example, if you see that there is an open invoice and a payment that should have been offset, you can use this button to jump to the open items on the vendor and offset the two items. Remember to select the Search button again afterwards to update the bank statement records. |
| Layout |
Save, retrieve, edit or delete a layout, i.e. the setup regarding the order of fields etc. in the screenshot |
| All fields |
Select this button to display all the fields of the vendor you have selected in the list and unfolded. Optionally, select the Unfold row button to unfold the vendor's records. |
Description of the bounding boxes
| Field name |
Field Description |
| From date
To date |
Fill in the fields with the date range you want to include on the bank statement |
| From account
To account |
Fill in the fields with the range of creditors to create statements for. |
| Rising |
If this field is checked, the oldest entries on the individual vendor will be shown at the top, i.e. if there are three entries on a vendor, dated in January, February and March respectively, the value in January will be shown at the top.
If this field is unchecked, the value from March will be shown at the top instead. |
| Omit empty |
If the Omit empty checkbox is selected, the creditors with no movement in the selected period will not be shown in the list when you select Search. |
| Postings
Open only
Overdue only |
All
If All is selected, all customer entries in the selected date range will be displayed. Open only
If you select Open only, only the records that are open in the selected date range are shown.
Note that only records that are still open but posted in the selected date range are shown.
The system does not store any information about when an item has been settled, so it is not possible to show which items were open at a given time. Only overdue
If you select Only overdue , only the creditors that have overdue items in the period are shown.
Note that if a customer has a prime balance on the from date, some or all of which is due, but new invoices in the selected period are not due, the creditor will not be included in the overview if you select Only due. |
| Page break |
If Page break is checked, a page break is inserted between each vendor if the internal account statement is printed. |
Bank statements can be printed and sent via the Printer icon [Ctrl+P]