1. Home
  2. Blog
  3. Accounting in ERP: From Source Documents to Financial Statements

Accounting in ERP: From Source Documents to Financial Statements

  • 7 min read
  • Tranquil team

Accounting in ERP follows the same double-entry rules as a paper ledger. What changes is who writes the entries. In a standalone accounting package, the accountant keys in most of them from invoices that arrive by email. In an ERP, the sales invoice, the goods receipt, the payroll run and the depreciation schedule post their own entries, and the accountant’s work moves to setting the rules, reviewing the results and fixing what falls outside them.

That shift is where most of the problems we see in implementation projects come from. A company that keeps posting manual journals out of habit after go-live ends up with two versions of the same transaction, and the month-end close gets longer instead of shorter.

How accounting in ERP posts entries from documents

Each operational document carries its own posting rule. Once the document is approved, the entry follows without anyone typing an account code.

Document Typical entry Who owns it
Sales invoice Customer, revenue and output VAT Sales and finance
Goods delivery or issue Cost of sales and inventory Warehouse
Goods receipt and supplier invoice Inventory or expense, input VAT and supplier Purchasing
Customer receipt or supplier payment Bank and the customer or supplier Finance
Payroll Salary expense, GOSI and salaries payable HR and finance
Asset depreciation Depreciation expense and accumulated depreciation Finance

What is left for manual journals is a short list: accruals that no document covers, reclassifications, corrections and a few period-end adjustments. If manual journals are still a large share of the entries a year after go-live, the posting rules or the way people use the documents need another look.

The chart of accounts and control accounts

The chart of accounts in an ERP should be shorter than the one most companies bring from their old package. Branches, departments and projects belong in cost centers or other dimensions on each line, not in separate accounts. A chart with “Salaries, Riyadh” and “Salaries, Jeddah” doubles every time the company opens a branch, while a single salaries account with a branch cost center gives the same report and keeps the chart stable.

Receivables, payables and inventory are control accounts. Their balance in the general ledger is the total of a subsidiary ledger, such as the customer balances, the supplier balances or the stock valuation. The rule that keeps them reliable is simple. Nobody posts to a control account directly. A manual journal that touches receivables should be posted against the customer, so that the customer statement and the ledger move together.

A worked example: one sale through the ledger

A distributor sells goods that cost 6,500 riyals for 10,000 riyals plus 15% VAT, and the customer pays two weeks later. The figures are hypothetical. Three documents produce three entries.

Document Account Debit (SAR) Credit (SAR)
Sales invoice SI2 Customer (receivables) 11,500.00
Sales revenue 10,000.00
Output VAT 1,500.00
Delivery GDN2 Cost of sales 6,500.00
Inventory 6,500.00
Receipt RCPT1 Bank 11,500.00
Customer (receivables) 11,500.00

Gross profit is 3,500 riyals and the customer’s balance is zero. The mistake we see most often is the accountant who also records the bank credit as a manual journal, debit bank and credit the receivables account. Cash is now overstated by 11,500, and because the journal hit the control account and not the customer, the customer aging still shows the invoice as open. The same pattern, and how to avoid it, is covered in accounting journal entries.

Closing the month in an ERP

Automatic postings make the close shorter only if the checks are done in order. A practical sequence for a trading or contracting company:

  1. Stop back-dated postings into the month once operations have finished their documents.
  2. Reconcile each bank account to its statement, and record bank charges and returned cheques from the bank reconciliation.
  3. Compare the receivables, payables and inventory control accounts with their subsidiary ledgers. A difference almost always points to a manual journal on the control account.
  4. Review goods received but not invoiced, unbilled revenue, accruals and prepayment releases.
  5. Run depreciation and check it against the asset register.
  6. Prepare the VAT return from the same postings and check output and input VAT against the ledger.
  7. Read the trial balance and the profit and loss against last month and the budget before anyone reports a number.

The order matters. A VAT return prepared before the supplier invoices for the month are posted will be amended later, and a stock count adjustment booked after the management pack has gone out makes the pack wrong.

Correcting entries after a period is reported

In an ERP, a posted entry is not deleted. It is reversed by an opposite entry and replaced by a correct one, so that the audit trail shows what happened and who did it. For an error found in the current year, the reversal and the new entry go in an open period with a clear narration.

An error from a year whose statements have already been issued is different. IAS 8 requires material prior period errors to be corrected retrospectively, by restating the comparative figures in the next statements, not by booking the whole difference in this year’s profit. In practice the accountant posts the entry through retained earnings and keeps a note of the restatement for the auditor. The mechanics are in correcting posted entries.

Financial statements and records

The statement of financial position, the statement of profit or loss and other comprehensive income, the statement of changes in equity and the statement of cash flows all come from the same ledger. If the trial balance is right and the account groups map cleanly to the statement lines, the statements need no spreadsheet in between. The cash flow statement is the one that still needs care, because the indirect method depends on how working capital accounts are grouped.

Two dates are worth knowing. IFRS 18 replaces IAS 1 for annual periods beginning on or after 1 January 2027, and changes how the profit or loss statement is subtotaled, so a chart designed now should be able to separate operating, investing and financing income and expenses. For VAT, the Implementing Regulations require invoices, records and accounting documents to be kept for at least six years from the end of the tax period they relate to, and longer for some capital asset records.

Accounting in Tranquil ERP

In Tranquil, account groups form a tree of assets, liabilities, income and expenses with auto-numbered codes, and accounts get nine-digit codes from their group. Each customer and supplier gets its own account under receivables or payables, so their balances sit inside those groups instead of beside them. Cost centers are kept as a tree and can be set on transactions, including customer receipts and supplier payments.

Sales, purchase, stock, payroll and asset transactions post to their own accounts. Manual journals, expenses and receipts can be kept as drafts and then posted, and their lines can be ledger, customer, supplier or bank lines. Prepayments generate a monthly release schedule, recurring transactions create expenses or receipts on a schedule, and the VAT Return page follows the boxes of the ZATCA return.

A financial year is closed with Entry Close. The finance reports include the day book, ledgers, trial balance, balance sheet, comparative profit and loss, cash flow and cost center reports. The module is described on the accounting system page.

Frequently asked questions

Does an ERP replace the accountant?

No. It removes most of the typing. The accountant still designs the chart of accounts and posting rules, reviews unusual postings, prepares accruals and corrections, reconciles the bank and control accounts, and signs off the close. Those are the parts that need judgment, and they are where errors are caught.

What is the difference between the general ledger and a subsidiary ledger?

The general ledger holds every account in the chart, with one balance per account. A subsidiary ledger holds the detail behind a control account, such as each customer’s invoices and receipts. The total of the subsidiary ledger should always equal the balance of its control account in the general ledger.

Can we keep using manual journals after moving to an ERP?

Yes, for entries no document covers, such as accruals, reclassifications and corrections. They should not be used for sales, purchases, receipts or payments that already have a document in the system, because the same transaction then posts twice.

How long should accounting records be kept in Saudi Arabia?

For VAT purposes, at least six years from the end of the tax period they relate to, under Article 66 of the VAT Implementing Regulations. Records relating to capital assets are kept longer, for the adjustment period plus five years. Other laws, such as company law, may set their own periods.

See what this article covers in Tranquil

In the demo we show what this article covers on Tranquil’s own screens and answer your team’s questions.

Dammam +966 13 848 8080, +966 13 817 7724, Riyadh +966 11 213 1330
[email protected]
Sunday to Thursday, 8 am to 5 pm.