Age-distributed balance list in Accounts Receivable and Accounts Payable

Follow
The report shows an overview of debtors who owe or will soon owe money to the company. You can divide the report into two different intervals. These are two very different reports depending on the choice in "grouping". Note! The distribution of the balance is only correct as of today's date. The distribution may differ back in time as Uniconta does not look at open items and equalizations back in time. When pre-invoicing, entries that are forward in time will be placed in the first column. See Alternative age-distributed balance...  

Local menu for age-distributed balance list

  1. Age range
    • Number of days between columns in the age distribution. 31 gives one month time interval
  2. Number of columns
    • Can be up to 10
  3. Currency
    • Select if records in a specific currency should be printed. Only shows records in this currency
  4. Omit "On hold" transactions
    • Set if outstanding items on hold should not be counted
  5. Include draft
    • Here you can choose whether unposted drafts can be included in the lists. You must group on 'Balance'.
    • ATTENTION! Remember to check for errors in the drafts you include. The draft will be included without a notification of any errors.
  For "Balance" grouping, the posting date is used to group the amount by. Fill in the date field with today's date, otherwise the wrong image of the balance list will be displayed. For "Balance due", the item "Due date" is used to group amounts by. If you choose this method, ALL open postings are searched. This is the same data basis as in the "Open postings" report, where data is simply grouped in columns. Note! You cannot make an 'Overdue balance' grouping back in time. It is possible to set up a filter and filter by debtors, account number, address etc. See more here: General - Layouts

Alternative age-distributed balance

When pre-invoicing and not wanting to see the pre-invoiced items, you can filter on debtor/creditor open items. Filter by date and group by account name to get the total in the overdue column.