FI Program Custom development Background program

Prepaid Expense and Deferred Revenue Accrual Program

Short answer: A custom program that spreads prepaid expenses such as insurance, rent, maintenance contracts and subscriptions, and revenue collected in advance, over their service period, posts the monthly expense or revenue entry automatically and, at year end, moves the part for later years to the long-term account. The remaining balance of each item is tracked together with its source invoice.

Estimated effort
M · 6–9 working days
System
ECC and S/4HANA
Tables
5
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

Recurring entries defined with FBD1 post a fixed amount on a fixed schedule; they do not prorate by day, link to the source invoice, track the remaining balance or split current and non-current. The standard Accrual Engine needs its own configuration and maintenance and is not set up in most systems. So prepaid expenses are usually tracked in a spreadsheet and posted by hand each month.

Who uses it? General ledger and month-end close teams, cost accounting and finance teams preparing for audit.

Closest standard alternatives

  • FBD1 Enter Recurring Entry. Defines recurring entries with fixed amounts; no daily proration or remaining balance tracking.
  • F.14 Execute Recurring Entries. Runs recurring entries; no link to the source invoice and no current/non-current split.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
BSISG/L Account Open Items (Secondary Index)Source items on prepaid expense and deferred revenue accountsReadECC + S/4
BSEGAccounting Document SegmentVendor/customer and text of the source invoiceReadECC + S/4
BKPFAccounting Document HeaderSource document header; monthly accrual documents createdRead / writeECC + S/4
SKB1G/L Account Master (Company Code)Company code settings of expense and prepaid accountsReadECC + S/4
CSKSCost Center Master RecordCost center validity checkReadECC + S/4

S/4HANA notes

  • BSIS → ACDOCA: In S/4HANA BSIS is no longer filled as a separate index table; it is read through a compatibility view of the same name. New developments should use ACDOCA or the related CDS views.

BAPIs and functions used

  • BAPI_ACC_DOCUMENT_POSTAccounting: Post Document. Posts monthly expense/revenue and year-end reclassification entries
  • BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Commits after each document

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueBKPF-BUKRSYes1000
P_BUDATPosting date (month end)Single valueBKPF-BUDATYes30.11.2026
R_ACTNAction: register items, monthly run or year-end reclassificationRadio button—NoAylık çalıştırma
S_HKONTPrepaid expense / deferred revenue accountsRange / multipleBSIS-HKONTNo1800000-1809999
P_TESTTest modeCheckbox—NoX

Input file columns

The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.

#ColumnTarget fieldRequired
1Source documentBSIS-BELNRYes
2Fiscal yearBSIS-GJAHRYes
3ItemBSIS-BUZEIYes
4Service startBy rule Day the accrual starts; the first month is proratedYes
5Service endBy rule Day the accrual ends; the last month is proratedYes
6Expense / revenue accountSKB1-SAKNRYes
7Cost centerCSKS-KOSTLNo

Sample upload file

1Source document *Fiscal year *Item *Service start *Service end *Expense / revenue account *Cost center
21900002214202600207/01/202606/30/202777001001100
31900002301202600210/15/202610/14/202877002502300
41900002388202600111/01/202601/31/20276490100
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1Source documentBSIS-BELNR
2TextBSEG-SGTXT
3Total amountBSIS-DMBTR
4Service periodCalculated Start – end date
5This monthCalculated Total amount × days in month / total days
6Posted to dateCalculated Previous months + this month
7RemainingCalculated Total amount − posted to date
8DocumentBKPF-BELNR
9StatusCalculated Test, posted, completed or error

Sample result list

Source documentTextTotal amountService periodThis monthPosted to dateRemainingDocumentStatus
1900002214Annual property insurance365,00001.07.2026 – 30.06.202730,000153,000212,000100007310Posted
1900002301Software maintenance contract (2 years)219,00015.10.2026 – 14.10.20289,00014,100204,900100007311Posted
1900002388Trade fair stand rental46,00001.11.2026 – 31.01.202715,00015,00031,000100007312Posted
A view built with fictional sample data; not real system data.

How does the program work?

  1. Invoices posted to prepaid expense and deferred revenue accounts are listed from BSIS and BSEG; for each item the user enters or uploads from Excel the service start and end date, the expense account and the cost center. Items are saved in the accrual table.
  2. The monthly amount is the total prorated by the number of days in the service period; the first and last months are partial, and the rounding difference goes to the last month.
  3. The monthly run posts the amounts due for the month with BAPI_ACC_DOCUMENT_POST, debiting the expense account and cost center (checked against CSKS) and crediting the prepaid account; the revenue side is the reverse.
  4. The posted and remaining amount of each item is updated; completed items are closed.
  5. At year end, the part falling after the next 12 months is reclassified to the long-term prepaid account and reversed on the first day of the new year.
  6. The G/L balance of the prepaid account is compared with the total remaining amount in the table and any difference is reported.

Performance notes

The monthly run only processes open accrual items; to reduce the number of documents, items can be grouped into one document by expense account and cost center.

Features

  • Export to Excel Service periods can be entered in bulk from Excel.
  • Test mode (check without posting)
  • Runs as a background job Runs automatically in the month-end close schedule.
  • Line-by-line result and error log
  • ALV list (sort, filter, subtotals)

Authorization objects

  • F_BKPF_BUKPosting authorization for the company code
  • F_BKPF_KOAAuthorization to post G/L account items

Frequently asked questions

Does it work for deferred revenue too?

Yes. When deferred revenue accounts are selected, the program posts the monthly revenue entry with the same logic; debit and credit are reversed.

What happens to the remaining amount if a contract ends early?

The end date on the item is brought forward; the whole remaining amount is expensed that month or, if selected, moved to a refund receivable account.

Can an internal order or WBS be used instead of a cost center?

Yes. An internal order or WBS element can be entered on the item instead of a cost center, and the posting uses that account assignment.

Related reports

FI Program Custom Mass upload

Mass G/L Journal Entry Upload from Excel

A custom program that posts multi-line G/L documents (accruals, reclassifications, allocation entries) in bulk from Excel or CSV rows. It checks every …

BKPF · BSEG · SKB1 · CSKS

FI Report Custom ALV report

Parked Documents Aging Report

A custom ALV report that lists parked accounting documents that are not yet posted by user, document type and waiting time. Before the period close it …

VBKPF · BKPF · VBSEGS · T001

Let us build this program for your system

Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.

Related report: Prepaid Expense and Deferred Revenue Accrual Program