Show TOC

Function documentationDown Payment Interim Account, Down Payment Clearing Account Locate this document in the navigation structure

 

Note Note

The automatic reconciliation functionality of these two accounts is not available in the following localizations, which have their own down payment handling process: Czech Republic, Slovakia, Hungary and Russia.

End of the note.

When a company receives or makes a down payment, the payment amount is recorded in an interim account before it’s deducted from the final transaction. For period end auditing purposes, the transactions that make up the value of the interim accounts must be easily auditable.

In SAP Business One, postings are made to the following two interim accounts in the down payment process:

  • Down payment clearing account

  • Down payment interim account

The postings to these two accounts are automatically reconciled as follows:

  • Down Payment Request Process

    When you create a payment for an A/R or A/P down payment request, the down payment interim account is debited or credited with the payment amount, and the down payment clearing account is credited or debited with the payment amount excluding tax.

    When you fully or partially draw the down payment to the final A/R or A/P invoice, the down payment interim account is credited or debited with the drawn amount, and the down payment clearing account is debited or credited with the drawn amount excluding tax.

    As a result, the postings to the down payment interim account and the down payment clearing account are fully or partially reconciled accordingly.

  • Down Payment Invoice Process

    When you create a full or partial payment for an A/R or A/P down payment invoice, the down payment clearing account is credited or debited with the invoice amount excluding tax.

    When you fully or partially draw the down payment to the final A/R or A/P invoice, the down payment clearing account is debited or credited with the drawn amount excluding tax.

    As a result, the postings to the down payment clearing account are fully or partially reconciled accordingly.

In the above two processes, if the final A/R or A/P invoice is then fully or partially drawn to a credit memo, the postings to the two accounts generated by the A/R or A/P invoice are proportionately reversed and reconciled.

However, if either of the two accounts has been fully, manually reconciled before the automatic system reconciliation takes place, SAP Business One does not perform the system reconciliation.

Note Note

You can cancel the automatic system reconciliation only if the document that triggers the reconciliation is cancelled.

End of the note.

Example Example

  1. You create a sales order as follows:

    Item No.

    Quantity

    Unit Price

    Total

    Tax

    A01

    50

    1

    50

    8.75

  2. You create an A/R down payment request based on the sales order and create an incoming payment for it as follows:

    Item No.

    Quantity

    Unit Price

    Total

    Tax

    Down Payment Made

    Total Payment

    Payment Means

    A01

    10

    1

    10

    1.75

    10

    11.75

    Cash

    The corresponding journal entry posting is as follows:

    Account

    Debit

    Credit

    Cash on Hand

    11.75

    BP Account

    11.75

    Down Payment Interim Account

    11.75

    VAT Payable (Output Tax)

    1.75

    Down Payment Clearing Account

    10

  3. You create a final A/R invoice based on the sales order and partially draw the down payment to it as follows:

    Item No.

    Quantity

    Unit Price

    Total

    Tax

    Net Amount to Draw

    Tax Amount to Draw

    Gross Amount to Draw

    A01

    50

    1

    50

    8.75

    4

    0.7

    4.7

    The corresponding journal entry posting is as below:

    Account

    Debit

    Credit

    BP Account

    58.75

    Down Payment Interim Account

    4.7

    Down Payment Clearing Account

    4

    VAT Payable (Output Tax)

    8.75

    VAT Payable (Output Tax)

    0.7

    Revenue Account

    50

    Inventory Account

    50

    Cost of Goods Sold Account

    50

SAP Business One automatically reconciles the postings to the down payment interim account and down payment clearing account as follows:

Account

Debit

Credit

Reconciliation Amount

Balance Due

Down Payment Interim Account

11.75

4.7

4.7

7.05

Down Payment Clearing Account

4

10

4

6

End of the example.

More Information

Interim Accounts