700
AvailableABP · Mohamad Zulfaiz Rofi
The Finance department’s own desktop app. Accounts Receivable first.
Why it exists
Finance reconciliation runs on spreadsheets rebuilt by hand every month. FinanceEco does the same work as a repeatable run against the department’s own exports, on the department’s own laptop — which outlet a payment belongs to, which day a cash deposit was for, whether this month’s files are all there — with the answer on screen instead of in a file somebody has to version.
What the current build covers
Impact
What the two lookups and the Fiuu helper changed for Accounts Receivable — measured on real months.
| Before | With FinanceEco | |
|---|---|---|
| Which outlet is this payment? | Work it out from a million-row export, or run the whole AR flow to get one column. | Outlet Code Lookup adds the outlet code, ownership, location and internal ID to every row. April 2026: 3,761,151 rows back, one for one — only 1 without an outlet code. |
| Sold in one month, settled in the next | Each row read against whatever month’s files were open. | Each row is looked up with the Sales Report and outlet list of the month it was sold in; a month not in yet says Waiting instead of guessing. |
| Which day was this cash deposit for? | The CASH workbook’s XLOOKUP on outlet and amount broke quietly on split, late or petty-cash deposits — each #N/A cost a filter and a calculator. | EOD Date Lookup works every deposit out from its parts — exact, split, nearest free day — and only what is genuinely unclear goes to To Do By Hand. |
| Cash banked over 7 days late | 28 of 40 such matches went through unflagged. | All 40 flagged Check, for a person to look at. (September against August.) |
| Naming Fiuu settlements | The totals typed into each file name by hand, one settlement at a time — and the names drifted. | Paste the portal’s SUMMARY box: the file is named, checked against a second download, and filed into its month. A 132,617-row settlement is read in 3.7 seconds. |
Source: FinanceEco’s Outlet Code Lookup, EOD Date Lookup and Fiuu Rename Helper docs — each proved on real data, 6 October 2026.
Who it is for
If none of these is you, it is probably not the tool you want — say so on the form and ABP will point you at the right one.
Finance — Accounts Receivable
The people this build is for. Rename and file the month’s downloads, look up outlet codes and EOD dates for a whole export, and check the month’s files before a run.
ABP — Automation Business Partner
Runs the reconciliation and the Finance Dashboard, and owns permissions and automation.
Finance — AP and General Ledger
Planned, not scoped. They appear on the opening screen today only as coming-soon cards.
Documentation
A walk through the app in the order you meet it, with the drawings from FinanceEco’s own Help screen — drawn rather than screenshotted, because most screens are full of real ledger figures. The recording at the top shows the ones that are not, with the one table of cash figures blurred.
Pick Accounts Receivable — the only real ledger today — then scan the Lark QR code with your phone. The first time, a Before You Start screen asks you to agree to the app’s rules, and a short tour follows.
Paste the SUMMARY box from the Fiuu portal, download the settlement file, and the helper names it from the totals and moves it from Downloads into the right month folder.
Adds the outlet code, ownership, location and the rest to every row of a raw export, without opening the Excel file and without a full run. Each row is looked up with the files for the month it was sold in; rows whose month is not in yet say Waiting.
Finds the EOD date each cash deposit was for, from the month’s CASH workbook. The ones it cannot settle go to a To Do By Hand tab, with the outlet’s nearby days to pick from; your picks go back into the workbook through Excel.
Before a run, checks the month’s folders: is every export there, in the folder it belongs in, with the tab and columns the engine needs. Create Folders makes the month’s folders for you.
ETL Pipelines and Dashboard Formulas show every rule behind the numbers, read-only. They began as Dr. Linh Vu’s QlikView script, and changing one moves the month’s figures — so it is agreed with Finance first and changed by ABP, not edited in passing.
Limits worth knowing
Written down because it is cheaper to read this now than to find it out in front of someone.
Who made it
Developer
Published by
Contributors
The details
Requires — Windows
Windows 10 or newer, 64-bit. A Lark account at ZUS. Excel, for writing picks into the CASH workbook.
Data safety
Written so you could check each line rather than take it on trust. If one of them turns out to be wrong, that is a bug in the tool, not a wording problem here.
Before you ask
Yes — ask here. It is built for Accounts Receivable, so if you work elsewhere in Finance, say what you would use it for and ABP will tell you whether it fits.
The Finance figures do not. The app reaches Lark to sign you in, to record that you agreed to its rules, and to record that it was used.
Support
Message ABP in Lark. That is the fastest route and it reaches whoever is closest to the problem.
Maintained by
Mohamad Zulfaiz Rofi, ABP
Where the source lives
Internal, on the ABP machines. There is no public repository and no third-party code hosting for any tool on this site.
