Automatic Posting of Utility, Telecom and Fuel e-Invoices with Account and Cost Center Determination
Short answer: A program that distributes the monthly electricity, gas, water, telecom and fuel e-invoices to the right G/L account and cost center by rules based on the supplier tax number, subscriber or installation number and vehicle plate, and posts them as vendor invoices. The non-deductible expense split for passenger cars, rounding and discount lines are also handled automatically by rule.
- Estimated effort
- L · 10–15 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
FB60 and FB10 enter the invoice by hand; e-invoice integration solutions bring the invoice into SAP but do not know which account and cost center the lines belong to. For hundreds of subscriptions and vehicles the same distribution is done by hand every month, the non-deductible share for passenger cars is calculated as a separate line and small rounding differences are a nuisance. FBD1 recurring entries do not suit invoices whose amounts change.
Who uses it? Accounts payable teams, general ledger, facilities and fleet management owners.
Closest standard alternatives
- FB60 Enter Incoming Invoices. Enters the vendor invoice by hand; no distribution rules by subscriber or plate.
- FB10 Invoice/Credit Memo Fast Entry. Offers fast invoice entry; the user still chooses the account and cost center.
- FBD1 Enter Recurring Entry. Sets up recurring entries with fixed amounts; does not suit invoices whose amounts change.
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| LFA1Vendor Master (General Section) | Vendor account from the supplier tax number | Read | ECC + S/4 |
| LFB1Vendor Master (Company Code) | Vendor company code data and reconciliation account | Read | ECC + S/4 |
| DFKKBPTAXNUMTax Numbers for Business Partner | Business partner tax numbers (S/4HANA) | Read | S/4HANA only |
| SKB1G/L Account Master (Company Code) | Expense account open for posting | Read | ECC + S/4 |
| CSKSCost Center Master Record | Cost center validity | Read | ECC + S/4 |
| T007ATax Codes | Tax code check | Read | ECC + S/4 |
| BKPFAccounting Document Header | Vendor invoice document; duplicate reference check | Read / write | ECC + S/4 |
| BSEGAccounting Document Segment | Distributed expense, non-deductible expense and tax lines | Write | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | Journal entry lines (S/4HANA) | Write | S/4HANA only |
BAPIs and functions used
- FI_DUPLICATE_INVOICE_CHECKDuplicate Invoice Check for Vendor Invoices. Blocks duplicate invoices
- BAPI_ACC_DOCUMENT_CHECKAccounting: Check Document. Checks the document without posting
- BAPI_ACC_DOCUMENT_POSTAccounting: Post Document. Posts the vendor invoice
- BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Saves successful documents
- CALCULATE_TAX_FROM_GROSSAMOUNTCalculate Tax from Gross Amount. Checks the tax amount from gross lines
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BKPF-BUKRS | Yes | 1000 |
| S_LIFNR | Supplier | Range / multiple | LFA1-LIFNR | No | — |
| S_BLDAT | Invoice date | Range / multiple | BKPF-BLDAT | No | 01.11.2026 – 30.11.2026 |
| P_BUDAT | Posting date | Single value | BKPF-BUDAT | Yes | 30.11.2026 |
| P_PARK | Park and send for approval instead of posting | Checkbox | — | No | — |
| P_TEST | Test mode | Checkbox | — | No | X |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Supplier | LFA1-LIFNR |
| 2 | Supplier name | LFA1-NAME1 |
| 3 | Invoice number | BKPF-XBLNR |
| 4 | Subscriber / plate | Calculated Subscriber, installation number or plate on the invoice |
| 5 | G/L account | BSEG-HKONT |
| 6 | Cost center | BSEG-KOSTL |
| 7 | Amount | BSEG-WRBTR |
| 8 | Non-deductible | Calculated Amount split with the rule rate on passenger car lines |
| 9 | Change vs previous month | Calculated (This month − last month) / last month |
| 10 | Document | BKPF-BELNR |
| 11 | Status | Calculated Posted, parked, rule pending, duplicate or error |
Sample result list
| Supplier | Supplier name | Invoice number | Subscriber / plate | G/L account | Cost center | Amount | Non-deductible | Change vs previous month | Document | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| 700501 | Örnek Elektrik Perakende A.Ş. | OEP2026000118734 | 4000873312 | 770100 | 1100 | 84,250 | 0 | 4 % | 5100004412 | Posted |
| 700610 | Demo Akaryakıt Ltd. | DAL2026000045120 | 34 ABC 123 | 770300 | 2300 | 18,640 | 5,592 | -2 % | 5100004413 | Posted |
| 700722 | Örnek Telekom A.Ş. | OTK2026000990211 | 5550001122 | 2,350 | 0 | Rule pending |
How does the program work?
- Invoices from the e-invoice integration are read: supplier tax number, invoice number and date, lines, taxes and the subscriber/installation number or plate on the invoice. The vendor account is found by the supplier tax number (LFA1-STCD1/STCD2 in ECC, business partner tax numbers DFKKBPTAXNUM in S/4HANA).
- The rule table is checked: supplier + subscriber/installation number → G/L account and cost center; supplier + plate → vehicle cost center and vehicle type (passenger/commercial). An invoice without a rule goes to the ‘rule pending’ list, and a rule defined once is used in later months.
- For passenger cars the non-deductible share is split to a separate expense account with the rate in the rule table; the rate and scope are entered during installation according to current regulation, the program has no fixed value. Rounding and discount lines are written to defined accounts.
- Checks that the G/L account is open for posting (SKB1), the cost center is valid (CSKS) and the tax code (T007A) fits; duplicate invoices are blocked with FI_DUPLICATE_INVOICE_CHECK.
- The document is checked with BAPI_ACC_DOCUMENT_CHECK and posted as a vendor invoice with BAPI_ACC_DOCUMENT_POST (BKPF, BSEG; ACDOCA in S/4HANA). Optionally it is parked first and sent to the invoice approval workflow.
- The result list shows supplier, subscriber/plate, distributed accounts, non-deductible amount and document number; a monthly comparison flags subscriptions whose amount rose clearly compared with the previous month.
Performance notes
Load the rule table once per supplier. For invoices with hundreds of lines such as fuel invoices, summarize the plate lines by cost center and account to reduce the number of document lines.
Features
- Test mode (check without posting)
- ALV list (sort, filter, subtotals)
- Line-by-line result and error log
- Runs as a background job Incoming e-invoices are processed automatically every day.
- Send the result by email Invoices waiting for a rule are notified to the owner.
Authorization objects
- F_BKPF_BUKPosting authorization for the company code
- F_BKPF_KOAAuthorization to post vendor and G/L items
- K_CSKSAuthorization to read cost center master data
Frequently asked questions
How is fuel distributed if the plate is not on the invoice?
If a vehicle ID system or card number is on the invoice, the rule is set up with the card number. If there is no distinguishing data, the invoice is posted to a default cost center and a distribution list can be uploaded separately.
What if the non-deductible rate changes?
The rate is kept in the rule table with a valid-from date; the new rate is entered from the relevant date and past invoices are not affected. The program contains no legal rate; the finance team maintains it according to current regulation.
Related reports
Journal Interface from External Systems with Account Mapping
A general-purpose interface that converts transactions from non-SAP systems such as a hotel management system, insurance, payroll or a front-office …
Incoming Invoice (e-Invoice and Paper) Approval Workflow and Tracking Cockpit
A cockpit that brings incoming e-invoices and scanned paper invoices into SAP and routes them to the right people for approval before posting. PO …
Türkiye e-Invoice, e-Archive and e-Waybill Outbound and Inbound Cockpit
A custom interface cockpit that sends billing documents and deliveries from SAP to the integrator as e-Invoice, e-Archive or e-Waybill, and receives …
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.