The down payment process in SAP involves recording a partial payment made to or received from a business partner before the final invoice, using either the classic down payment or the newer down payment request functionality. You enter the down payment via a special G/L account, post it against a customer or vendor, and later clear it when the final invoice is posted. This guide explains the exact transaction codes, posting steps, and clearing procedures for both customer and vendor down payments.
Formula
The down payment process itself does not use a financial formula, but the payment amount you enter is part of the standard accounting equation. The formula for the monthly payment on a loan (shown above) is included here as a reference for calculating the down payment amount if you are financing the remainder. The formula is:
PMT = P * (r / (1 – (1 + r)^-n))
Where:
- PMT = monthly payment (in $)
- P = loan principal (the amount financed after down payment, in $)
- r = monthly interest rate (APR divided by 12, expressed as a decimal)
- n = total number of payments (loan term in years * 12)
Worked Example
Using the default values from the calculator above: P = $5,000, APR = 8% (so r = 8/1200 = 0.0066667), term = 5 years (n = 60).
- Calculate r: 8 / 1200 = 0.0066667
- Calculate (1 + r)^-n: (1.0066667)^-60 ≈ 0.67121
- Calculate denominator: 1 – 0.67121 = 0.32879
- Calculate payment: 5000 * (0.0066667 / 0.32879) = 5000 * 0.020276 = 101.38
The monthly payment is $101.38. Total interest over 5 years = (101.38 * 60) – 5000 = 6082.80 – 5000 = $1,082.80.
Assumptions
- Fixed interest rate for the entire term.
- Payments are made at the end of each month.
- Interest compounds monthly at APR/12.
- This calculator does not include fees, taxes, or insurance.
Understanding Down Payments in SAP
In SAP ERP (and S/4HANA), a down payment is a partial payment made before the final invoice. It is not a normal invoice; it is a special G/L transaction that creates a down payment line item on the customer or vendor account. The purpose is to reduce credit risk or to fund production before delivery.
There are two main types:
- Customer down payment (incoming): You receive money from a customer before delivering goods or services.
- Vendor down payment (outgoing): You pay a vendor before receiving goods or services.
Each type uses a special G/L account (e.g., down payments received or down payments made) to separate these transactions from regular receivables and payables.
How to Post a Customer Down Payment
To post a customer down payment, use transaction F-28 (or F-29 for vendor down payments). The steps are:
- Enter transaction code F-28 in the command field.
- Enter the customer account, company code, and posting date.
- Enter the amount and the special G/L indicator (e.g., ‘A’ for down payment received).
- Enter the bank account or cash account as the offsetting entry.
- Post the document. The system creates a down payment line item with a special G/L indicator.
For vendor down payments, use F-29 and special G/L indicator ‘A’ (down payment made). The offsetting entry is typically a bank account.
Clearing Down Payments
When the final invoice is posted, the down payment must be cleared against it. This is done with transaction F-32 (for customers) or F-44 (for vendors), or through automatic clearing programs.
The clearing process:
- Post the final invoice (e.g., with FB70 for customer invoice).
- Run transaction F-32 to clear open items.
- Select the down payment line and the invoice line.
- Post the clearing. The system creates a clearing document that reduces the receivable/payable by the down payment amount.
If the down payment is greater than the invoice, a credit balance remains, which can be refunded or carried forward.
Down Payment Requests vs. Down Payments
SAP also offers down payment requests (transaction F-37 for customers, F-47 for vendors). A down payment request is not a posting; it is a request to the customer/vendor to pay. It does not create a G/L entry. Once the payment arrives, you post it as a down payment (F-28/F-29) referencing the request.
This is useful for sending a formal request document (e.g., PDF) to the customer before the actual payment.
Common Problems and Misconceptions
- Using the wrong special G/L indicator: The indicator must match the down payment type (e.g., ‘A’ for down payment received, ‘B’ for down payment made). Using the wrong one leads to incorrect balance sheet presentation.
- Forgetting to clear: If you do not clear the down payment, the customer account shows both an invoice and a down payment as open items, causing confusion and incorrect aging reports.
- Posting down payment as a regular invoice: Some users mistakenly post a down payment as a normal invoice (FB70), which inflates revenue and creates a false receivable. Down payments must use special G/L accounts.
- Misconception: Down payment requests are postings: A request is not a posting; it is just a document. You must post the actual payment separately.
Frequently Asked Questions
What is the transaction code for customer down payment?
Use F-28 for customer down payment posting. For vendor down payment, use F-29. For down payment requests, use F-37 (customer) and F-47 (vendor).
How do I clear a down payment in SAP?
Use transaction F-32 for customer clearing or F-44 for vendor clearing. Select the down payment line and the invoice line, then post the clearing.
What is a special G/L account?
A special G/L account is a separate account used to record down payments, so they do not appear as regular receivables/payables. In SAP, you assign a special G/L indicator (like ‘A’) to a G/L account in the account determination.
Can I reverse a down payment?
Yes, you can reverse a down payment document using FB08 (reverse posting) if it was posted incorrectly. However, if the down payment has been cleared, you must first reverse the clearing document.
What is the difference between a down payment and an advance payment?
In SAP, they are the same concept. Down payment is the common term, but advance payment is used interchangeably. Both refer to a payment made before the final invoice.
How does down payment affect the balance sheet?
Customer down payments received are shown as liabilities (down payments received) on the balance sheet. Vendor down payments made are shown as assets (down payments made). This ensures that the company does not show revenue or expenses before the actual sale or purchase.
Conclusion
The down payment process in SAP is straightforward once you understand the special G/L accounts and clearing steps. Always use the correct transaction codes and clear down payments promptly to keep your financial statements accurate. This guide provides the general process; your specific SAP implementation may have additional configuration steps.
The result is an estimate; your lender’s disclosure gives the exact figures.
Related
Formula used
in p | Down payment amount | $ | 5000 | 0 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- QNB Car Loan Payment Calculator and Guide$405.53
- Car Loan Payment Calculator and Formula$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- DIB Bank Car Loan Calculator and Payment Guide$405.53