Configure bank statement settings

You specify the settings per administration for importing the bank statements. These settings allow you to limit the number of criteria Profit checks when processing. The more you limit this option, the faster the processing will be.

You must specify these settings for both manually and automatically importing bank statements via the bank link.

To configure administration settings for bank statements:

  1. Go to: Financial / Management / Administration settings.
  2. Go to the tab: Read bank statements.
  3. Write off deb. collection from acc. ‘Payments in transit’ if you are using automatic collection from debtors:
    • Select this check box if the bank delivers collections entry-by-entry in the bank statement file.
    • Deselect this check box if the bank delivers collections as one amount in the bank statement file.

    This depends on the agreements you have reached with the bank (or banks) regarding the delivery of collections.

    When compiling the payment file, you use a suspense account, the ledger account Payments in transit. This ledger account is linked to the properties of the bank account (the bank account you use to generate the collection order). When you generate the payment file, you immediately write off the outstanding items from the debtors and debit this suspense account. When you process the bank statement with the collection, you also post the amount collected to the suspense account Payments in transit (but now as credit) so that the suspense account is once again balanced. If you process the bank statement automatically, Profit automatically enters the collected amount on the suspense account Payments in transit.

  4. Enter cred.paym. on "Payments in transit" account if you are using automatic payment of creditors:
    • Select this check box if the bank delivers creditor payments entry by entry in the bank statement file.
    • Deselect this check box if the bank delivers creditor payments as one amount in the bank statement file.

    This depends on the agreements you have reached with the bank (or banks) regarding the delivery of creditor payments.

    If you have a bank that delivers the payments per creditor (entry by entry) as well as a bank that delivers them as one amount, select the check box.

    When compiling the payment file, you use a suspense account, the ledger account Payments in transit. This ledger account is linked to the properties of the bank account (the bank account you use to generate the payment order). When you generate the payment file, you immediately write off the outstanding items from the creditors and credit this suspense account. When you process the bank statement with the payment, you also post the amount paid to the suspense account Payments in transit (but now as debit) so that the suspense account is once again balanced. If you process the bank statement automatically, Profit automatically enters the paid amount on the suspense account Payments in transit.

  5. If you are invoicing using Profit, enter the value 1 in Invoice number start position.

    Position 1 is the starting position of the invoice number from the invoicing process in the payment reference. Are you using third-party software for invoicing? If so, consult the supplier for the correct position of the invoice number in the payment file.

  6. Enter a value in Invoice number length.

    You can find the correct value in the following way:

    1. Go to: General / Configuration / Numbering settings / Counters.
    2. Open the properties of the Sales invoice counter in the current administration.

    The required value can be found in the Total length field.

  7. Only enter the data in the Match debtors by social security number (‘BSN’) box if you want to reconcile on this.

Directly to

  1. Configure electronic bank statements
  2. Configure the bank statement settings
  3. Configure a bank ledger account
  4. Configure a bank statement journal
  5. Configure a voucher number counter for a bank journal
  6. Add a bank transaction code
  7. Add a bank transaction code with allocation
  8. Configure Equens payments
  9. Configure the reconciliation of bank statements by ‘BSN’