The accrual method management

Documentation •
In this article


Banana Accounting allows you to manage the customers both on an accrual or cash method. A detailed explanation is available at the page Accounting with accrual or cash method.

The following explains how to set up separate accounts for each customer and a group for customers, so that you can have a list of separate invoices per customer available.

In case you only have few invoices and don't want to keep a detail per customer, you may also keep one single account only to record all customer invoices. The list of invoices will thus apply for all customers and not for any single customer.

Setting up the Customers' register

The customer ledger with its accounts and/or groups is inserted at the end of the chart of accounts with a separate section.

The following settings must be added to create the ledger:

  • A * section (header)  (see Sections)
  • A 01 section for the Customers (see Sections)
  • The Customers accounts that are required (see Adding a new account). Each customer will be allocated one row in the Chart of Accounts and a his/her single account number.  Account numbers is at your discretion (see Accounts) it is however advisable to use numbers only, especially for the management of payments.
  • A group where all customer accounts are totaled.
  • This group, in turn, is totaled into a group present in the Assets.

Alternatively, customer accounts and/or groups can be entered directly in the assets section.

set up the client register

  • The total for Customers will be totaled in the summary group 110A of the Sum in column.
  • The same code or number used in the Sum in column (110A), must be used in the Assets Group column, in the row corresponding to the Total Customers of the Balance Sheet.
  • The groups' numbering can be freely chosen (see Groups).

Customer group connected to the balance sheet

Recording an issued invoice

The issued invoice is registered by entering the following data in the respective columns:

  • Date of the invoice and any document number
  • Invoice number - It is very important to enter the invoice number in the Invoice column, because it is used to automate the various customer reports and to automatically close the customer's open invoice when recording the payment.
  • Customer Debit and Credit of revenue Accounts
  • The VAT code corresponding to the sales.

Recording an issued invoice

Recording a payment

The collection of a customer invoice is recorded by entering the following data in the respective columns:

  • In the Date column enter the transaction date
  • In the Type column enter 11 (customer payment)
  • In the Invoice column enter the paid invoice number.
    • With a double-click on the cell, the program will show a list of all open invoices.
      Alternatively, you may also press the F2 button. If the F2 button doesn't work, you need to activate your customers/suppliers settings, by entering your customers register group, via the Reports menu → Customers → Settings.
    • Select the number of the paid invoice. The program will automatically enter:
      • In the Description column, the payment description
      • In the the Credit account column, the customer account number
      • In the Amount column, the invoice amount.
  • In the Debit column, you must manually enter the counterpart (the bank account where the amount has been credited).

Enter the account into which the invoice amount was paid. As soon as the contra account is posted, the difference in the postings will not be displayed.

Recording a payment

Recording a debit note

In order for the amount to be deducted from the initial invoice, the same invoice number must be used.

  • If the adjustment document (for example a debit note) has a different numbering that you still need to keep available, write this reference in another column, for example Doc Original.
  • The VAT Code must be preceded by the minus sign "-" so that the VAT operation is reversed, or use a specific VAT Code for debit notes (set in the VAT Codes table).

Note: to print the debit note to be sent to the customer, it is necessary to indicate in the DocType: 12 column, see Entering a credit note.Recording a credit note

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email