calculate-loan

01 Loan payments

Down Payment in SAP T Code: How to Post

Calculator No. 01-25118 · Updated · Formula and assumptions shown below

Future value $5,126.31
Interest earned
$126.31
= Future value − down payment amount
Down payment amount
$5,000
Input
Annual interest rate (APR)
5 %
Input
You enter
Down payment amount ($), Annual interest rate (APR) (%), Months until delivery (months)
You get
Future value ($), Interest earned ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

The SAP transaction code for posting a customer down payment is F-29, and for a vendor down payment it is F-48. You enter the customer or vendor, the amount, the posting date, and the clearing account; SAP then creates a customer/vendor line item and a corresponding general ledger (G/L) account posting.

Formula

The calculator above computes the future value of a down payment if you were to hold it in an interest-bearing account until the delivery date. The formula is:

FV = P × (1 + r / 1200) ^ n

  • P = down payment amount (in your currency, shown as $ here)
  • r = annual interest rate (APR, in percent per year)
  • n = number of months until the payment is due
  • FV = future value after n months, rounded to 2 decimals

The monthly rate is the annual rate divided by 12 (and by 100 to convert percent to a decimal). This is the standard compound interest formula for monthly compounding.

Worked Example

Using the default values from the calculator block:

  • P = $5,000
  • r = 5% per year
  • n = 6 months

Monthly rate = 5 / 1200 = 0.0041666667

FV = 5000 × (1 + 0.0041666667) ^ 6

FV = 5000 × (1.0041666667) ^ 6

FV = 5000 × 1.025262 = $5,126.31

The calculator shows $5,126.31, matching the step-by-step result.

Assumptions

  • Interest is compounded monthly at APR / 12.
  • The down payment is deposited at the start of the period and no additional deposits or withdrawals are made.
  • The result assumes the interest rate stays constant for the entire period.
  • No taxes, fees, or inflation are considered.

This is an estimate; the actual future value depends on your bank’s compounding method and rate changes.

What Is a Down Payment in SAP?

In SAP ERP (and S/4HANA), a down payment is a partial payment made before the final invoice. It can be a customer down payment (you receive money from a customer before delivering goods or services) or a vendor down payment (you pay a vendor before they deliver). These are not regular invoices; they are special G/L transactions that create a down payment line item and a clearing account balance.

SAP uses dedicated transaction codes for each type:

  • F-29 – Post customer down payment
  • F-48 – Post vendor down payment
  • F-30 – Clear customer down payment (when the final invoice is posted)
  • F-54 – Clear vendor down payment

These transactions are part of the Financial Accounting (FI) module. They require that you have a customer or vendor master record and that the down payment G/L accounts are defined in your chart of accounts.

How to Post a Down Payment Using F-29

Follow these steps to post a customer down payment:

  1. Enter transaction code F-29 in the command field.
  2. Enter the Document Date, Posting Date, and Company Code.
  3. In the Account field, enter the customer number (or use the search help).
  4. Enter the Amount in the document currency.
  5. Choose a Payment Method (e.g., check, bank transfer).
  6. In the G/L account field, enter the down payment clearing account (e.g., 139999 for customer down payments).
  7. Press Enter to see the posting preview, then Post.

SAP will generate a document with two line items: one for the customer (debit) and one for the clearing account (credit). The customer balance increases, and the clearing account shows the liability (for customer down payments) or asset (for vendor down payments).

How to Choose the Right Clearing Account

The clearing account is a G/L account that holds the down payment until it is cleared against the final invoice. In many companies, the chart of accounts includes separate accounts for:

  • Customer down payments received (liability account)
  • Customer down payments made (asset account)
  • Vendor down payments made (asset account)
  • Vendor down payments received (liability account)

Your finance team defines these accounts in the system. When posting, you must select the correct one based on the nature of the transaction. If you use the wrong account, the financial statements will misstate assets or liabilities.

You can also use the Alternative Account field to specify a different account for the down payment, which is useful when you need to separate down payments by project or business area.

Common Problems and How to Avoid Them

  • Wrong account type – Posting a down payment to a regular customer account instead of a special G/L account. Always use F-29/F-48, not FB50.
  • Missing down payment indicator – The down payment indicator (e.g., A for customer down payment) must be set in the special G/L transaction. If it is missing, the system may treat it as a normal invoice.
  • Clearing errors – When you post the final invoice, you must clear the down payment using F-30 or F-54. If you forget, the clearing account remains open and the balance sheet is wrong.
  • Currency mismatches – If the down payment is in a foreign currency, ensure the exchange rate is correct at posting time. SAP uses the rate from the posting date.
  • Double posting – Posting the same down payment twice because the first document was not saved. Always check the document number before re-entering.

Down Payment vs. Advance Payment

In SAP, the terms are often used interchangeably, but there is a subtle difference. A down payment is a partial payment made before the final invoice, while an advance payment can refer to a full prepayment. In SAP, both are handled with the same transaction codes (F-29/F-48) and the same special G/L accounts. The only difference is the amount and the clearing process. Some companies use separate accounts for partial vs. full prepayments, but that is a configuration choice.

Another related concept is the down payment request (transaction F-37 for customers, F-47 for vendors). This is a request you send to the customer/vendor asking for the down payment, but it does not post anything to the general ledger. You must still post the actual down payment when the money arrives.

How to Report on Down Payments

You can view open down payments using standard reports:

  • FBL1N – Vendor line items (filter by special G/L indicator)
  • FBL5N – Customer line items (filter by special G/L indicator)
  • S_ALR_87012077 – Customer down payments report
  • S_ALR_87012082 – Vendor down payments report

These reports show the open amounts, the clearing documents, and the posting dates. They are useful for reconciliation and for monitoring prepayments.

Frequently Asked Questions

What is the difference between F-29 and F-48?

F-29 is for customer down payments (money you receive), while F-48 is for vendor down payments (money you pay). The posting logic is the same, but the account types and the special G/L indicators differ. F-29 posts to a customer account, F-48 to a vendor account.

Can I post a down payment without a purchase order?

Yes, you can post a down payment directly using F-29 or F-48 without a purchase order or sales order. You only need a customer or vendor master. However, if you want to link the down payment to a specific order, you can enter the order number in the reference field, but it is not mandatory.

How do I clear a down payment in SAP?

Use transaction F-30 for customer down payments and F-54 for vendor down payments. When you post the final invoice, you can clear the down payment by entering the down payment document number in the clearing transaction. The system will match the amounts and close the clearing account.

What is the special G/L indicator?

The special G/L indicator (e.g., A for customer down payment, B for vendor down payment) tells SAP that the posting is not a regular invoice but a down payment. It is used to separate down payments in the line item display and to determine the correct clearing account.

Why is my down payment not showing in the customer balance?

Down payments are posted to special G/L accounts, not to the regular customer account. By default, the customer balance might not include down payments unless you run a report that includes special G/L transactions. Use FBL5N and select the special G/L indicator to see them.

Can I reverse a down payment in SAP?

Yes, you can reverse a down payment document using transaction FB08 (reverse posting). However, you should only reverse it if the down payment has not been cleared. If it has been cleared, you must first reverse the clearing document, then reverse the down payment.

Always remember that the result of the calculator above is an estimate; the exact future value depends on your bank’s interest rate and compounding method.

Related

Formula used
in p | Down payment amount | $ | 5000 | 1 | 100000000
in apr | Annual interest rate (APR) | % | 5 | 0.01 | 100
in yrs | Months until delivery | months | 6 | 1 | 600
out fv | Future value | $ | p * (1 + apr / 1200) ^ yrs | 2
out int | Interest earned | $ | fv - 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

The whole Loan payments section →