MyInvois, Marketplace Payouts and Bank Deposits: The New Reconciliation Gap
Nobody warned Siti about the third document.
She's been doing bank reconciliation for her SME clients for years. The workflow was painful but manageable: download the Shopee payout statement, download the bank statement, open Excel, start matching. A few hours per client, longer if the numbers were messy.
Then MyInvois arrived.
Now there's a third source of records that needs to align with the other two — and the existing tools weren't built for it.
What changed
Malaysia's e-Invoice mandate began rolling out in August 2024, phased according to annual turnover or revenue. Businesses with annual turnover or revenue above RM1 million and up to RM5 million fall within the later implementation phases, while taxpayers below RM1 million may qualify for exemption, subject to HASiL's eligibility conditions.
The intention is good . Stronger tax compliance, greater transaction transparency, and more structured digital records.
But it introduced a new operational challenge that many accounting workflows were not designed to handle.
The 3-Way Match Problem
Here's what Siti may now need to reconcile each month for e-commerce clients within the e-Invoice framework:
Source 1 : MyInvois-related records
For sales completed through an e-commerce platform, the platform itself may be responsible for issuing buyer-facing e-Invoices or receipts, as well as self-billed e-Invoices that record the merchant's income. The platform may also issue separate e-Invoices for commissions and other charges, plus refund notes and other adjustment records where applicable.
This means there isn't simply one merchant-issued invoice per sale. There's a set of platform-generated records , income, fees, adjustments , that all need to be accounted for.
Source 2 : Shopee / Lazada payout statement
One net figure per settlement period. Behind that single number: platform commissions, shipping fees, voucher subsidies, refund deductions, promo cost-sharing. Multiple line items bundled into one payout.
Source 3 : Bank statement
What actually landed. Sometimes split across multiple settlement batches. Sometimes arriving on a different date from the settlement period. The net deposit rarely matches the gross sales figure on first look , because it shouldn't. Fees and adjustments have already been deducted.
The accountant's job isn't to make all three numbers identical. It's to create a traceable bridge:
Sales and income records − fees − refunds ± adjustments = net settlement deposited
In practice, building that bridge without proper tooling means significant manual work every month.
Why spreadsheets get hard fast
Basic spreadsheet matching works reasonably well when two clean datasets share common references. It becomes much harder when three systems use different identifiers, dates, and levels of aggregation.
Specifically, Siti is dealing with:
Different date formats across three systems
Transaction IDs that don't cross-reference between sources
Bundled payouts that need to be unpacked before matching can begin
Refunds and adjustment records that appear in one source but not another
A skilled accountant can work through this. In our early conversations with accountants managing e-commerce clients, the recurring theme is time , matching three sources manually, especially when payouts are bundled and dates don't align, is the kind of work that fills an afternoon. Across a full client roster, it adds up fast.
What this means for freelance accountants
The accountants serving Malaysian SMEs , the Sitis of the market , are absorbing this complexity quietly. Some are charging more. Some are working longer hours. Some are handling it by spending time they don't bill for.
None of these are sustainable at scale.
The irony is that MyInvois was designed to make compliance easier. For the SME owner, it may well do that. For the accountant doing the downstream reconciliation, it introduced another layer of records into a workflow that was already stretched.
The workflow gap
Malaysian accounting software has come a long way. Many platforms handle invoicing, payroll, and GST/SST workflows well, and some connect with marketplaces or third-party integration services.
What we haven't found is a simple workflow focused specifically on bringing together MyInvois related records, detailed marketplace settlements, and actual bank transactions in one explainable reconciliation report. Many businesses can integrate parts of the process. The harder part is investigating why the final numbers don't align and identifying the specific fees, refunds, timing differences, or missing records behind each exception.
That's the problem Rekons is being built to address.
What we're building
Rekons is a reconciliation tool for Malaysian SMEs and the freelance accountants who serve them. Import your bank transactions, marketplace payout data, and MyInvois related records and Rekons helps identify where they match, where they don't, and flags the exceptions for your review.
No manual VLOOKUP. No copy-pasting across three tabs. Just a clear reconciliation report you can review with your client and retain as supporting documentation.
We're in early testing now. If you're a freelance accountant managing e-commerce clients or an SME owner doing your own books , I'd love to show you what we're building.
👉 https://rekons.io/
Rekons is starting with bank reconciliation. Built in Malaysia, for Malaysia.