Transaction Categorizer
Sorts bank and card transactions into your chart of accounts the way you’ve booked them before, and flags what needs a person.
- Categorizes transactions
- Suggests bank rules
About
Upload the bank or card transactions and a few months you’ve already categorized. The agent learns how you booked each payee, even when the bank adds store numbers and card codes, and suggests an account for every new line.
Lines it can’t match from history, it decides from your chart of accounts and says why. Transfers, duplicates, refunds, loan payments and unusual amounts are flagged for a person.
What it needs
- Bank or card transactionsCSV, Excel or a PDF statementRequired
- Past categorized transactionsA GL or transaction detail export, two or three monthsRecommended
- Chart of accountsSo every suggestion is an account you haveRecommended
What you get
- An account for every transaction, with its confidence and reason
- The lines that need a person, at the top
- Totals by account
- Bank rules for payees you always book the same way
Example
March, checking account17 transactions
12 categorized from January and February. 9 flagged for a person, including:
| Bank description | Amount | Account | Why |
|---|---|---|---|
| ACH DEBIT WINGTIP RENTALS LEASE 0301 | ($1,100) | Rent & Lease | Same payee, 2 of 2 past |
| CHECKCARD 0304 FABRIKAM OFFICE #0457 SEATTLE WA | ($612.40) | Office Supplies | Same payee, 3 of 3 past |
| CHECKCARD 0306 CONTOSO FREIGHT 4471 | ($1,244) | Freight & Delivery | Possible duplicate |
| CHECKCARD 0309 FABRIKAM OFFICE #0457 SEATTLE WA | $212.40 | Office Supplies | Refund |
| ACH DEBIT EXAMPLE BANK LOAN PMT | ($2,150) | Notes Payable | Split principal and interest |
| CHECKCARD 0310 MARGIES TRAVEL 5521 PORTLAND OR | ($486.20) | — | New payee: decided from the chart |
How it works
- Learn each payee from your history
- Match the new transactions
- Decide new payees from the chart of accounts
- Flag what needs a person
Start it in Jiro
Open a new session, attach your files and send:
/transaction-categorizer Categorize March for the checking account. The bank export, January and February’s GL detail and our chart of accounts are attached.
Upload your bank transactions. Our agents get to work.
More agents
- ReconciliationsFree download
Bank Reconciliation
Matches the bank statement to the general ledger, ties out both sides and drafts the entries for review. - ReconciliationsFree download
Difference Finder
Finds why a reconciliation won’t tie: swapped digits, items on the wrong side, and the entries that add up to the gap. - Close support
Workpaper Writer
Shows how every number in an answer was derived, step by step, with the calculation behind each one.