Run the monthly close reconciliationQuickBooks / NetSuite + Google Sheets
Match the ledger to the bank, automatically.
View workflow →- Export the GL.
- Match to the bank feed.
- Flag unreconciled lines.
- Note exceptions.
- Pull GL + bank feed.
- Match transactions.
- Flag unreconciled lines and likely duplicates.
- Write an exceptions tab for review.
Trigger · Schedule, 1st of the month 06:00. 1. QuickBooks / NetSuite · Get last month's general-ledger entries. 2. Bank feed · Get the month's transactions. 3. Array aggregator · match on amount, date, and reference. 4. Router · split unmatched entries from probable duplicates. 5. Google Sheets · write a "Close Exceptions" tab: each item, its amount, and why it was flagged for a human to clear.