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
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| BSISG/L Account Open Items (Secondary Index) | Source items on prepaid expense and deferred revenue accounts | Read | ECC + S/4 |
| BSEGAccounting Document Segment | Vendor/customer and text of the source invoice | Read | ECC + S/4 |
| BKPFAccounting Document Header | Source document header; monthly accrual documents created | Read / write | ECC + S/4 |
| SKB1G/L Account Master (Company Code) | Company code settings of expense and prepaid accounts | Read | ECC + S/4 |
| CSKSCost Center Master Record | Cost center validity check | Read | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BUKRS | Company code | Single value | BKPF-BUKRS | Yes | 1000 |
| P_BUDAT | Posting date (month end) | Single value | BKPF-BUDAT | Yes | 30.11.2026 |
| R_ACTN | Action: register items, monthly run or year-end reclassification | Radio button | — | No | Aylık çalıştırma |
| S_HKONT | Prepaid expense / deferred revenue accounts | Range / multiple | BSIS-HKONT | No | 1800000-1809999 |
| P_TEST | Test mode | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Source document | BSIS-BELNR | Yes |
| 2 | Fiscal year | BSIS-GJAHR | Yes |
| 3 | Item | BSIS-BUZEI | Yes |
| 4 | Service start | By rule Day the accrual starts; the first month is prorated | Yes |
| 5 | Service end | By rule Day the accrual ends; the last month is prorated | Yes |
| 6 | Expense / revenue account | SKB1-SAKNR | Yes |
| 7 | Cost center | CSKS-KOSTL | No |
Sample upload file
| 1 | Source document * | Fiscal year * | Item * | Service start * | Service end * | Expense / revenue account * | Cost center |
|---|---|---|---|---|---|---|---|
| 2 | 1900002214 | 2026 | 002 | 07/01/2026 | 06/30/2027 | 7700100 | 1100 |
| 3 | 1900002301 | 2026 | 002 | 10/15/2026 | 10/14/2028 | 7700250 | 2300 |
| 4 | 1900002388 | 2026 | 001 | 11/01/2026 | 01/31/2027 | 6490100 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Source document | BSIS-BELNR |
| 2 | Text | BSEG-SGTXT |
| 3 | Total amount | BSIS-DMBTR |
| 4 | Service period | Calculated Start – end date |
| 5 | This month | Calculated Total amount × days in month / total days |
| 6 | Posted to date | Calculated Previous months + this month |
| 7 | Remaining | Calculated Total amount − posted to date |
| 8 | Document | BKPF-BELNR |
| 9 | Status | Calculated Test, posted, completed or error |
Sample result list
| Source document | Text | Total amount | Service period | This month | Posted to date | Remaining | Document | Status |
|---|---|---|---|---|---|---|---|---|
| 1900002214 | Annual property insurance | 365,000 | 01.07.2026 – 30.06.2027 | 30,000 | 153,000 | 212,000 | 100007310 | Posted |
| 1900002301 | Software maintenance contract (2 years) | 219,000 | 15.10.2026 – 14.10.2028 | 9,000 | 14,100 | 204,900 | 100007311 | Posted |
| 1900002388 | Trade fair stand rental | 46,000 | 01.11.2026 – 31.01.2027 | 15,000 | 15,000 | 31,000 | 100007312 | Posted |
How does the program work?
- 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.
- 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.
- 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.
- The posted and remaining amount of each item is updated; completed items are closed.
- 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.
- 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
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 …
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 …
Subledger vs Reconciliation Account Balance Check Report (S/4HANA Migration Check)
A custom ALV report that totals customer and vendor subledger balances by reconciliation account and compares them with the G/L account balance for …
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.