Workflow · Finance close · Opening soon
Journal entry upload from a spreadsheet
Check your journal entry spreadsheet before upload. Match accounts to the chart of accounts, then check that each entry balances.
Someone typed
“check this journal entry spreadsheet before upload: debits equal credits for each entry and every account exists in the chart of accounts”
The agent read it as
Check this Journal entry spreadsheet before upload: debits equal credits for each entry and every account exists in the Chart of accounts.
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
File
Journal entry spreadsheet
CSV export · 16 rows
File
Chart of accounts
CSV export · 14 rows
Join
Match chart accounts
15 of 16 paired
Step
Check entries and accounts
Step 2
Result
Journal Entry Checks
16 rows
Schedule
Runs when you say
Proposed
- FileJournal entry spreadsheetCSV export · 16 rows
- FileChart of accountsCSV export · 14 rows
- JoinMatch chart accounts15 of 16 paired
- StepCheck entries and accountsStep 2
- ResultJournal Entry Checks16 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out, and the join paired 15 of 16 rows.
- Download Journal entry spreadsheet sample (16 rows)Excel: File > Save As > CSV from the workbook sheet 'Journal Entries'
- Download Chart of accounts sample (14 rows)Excel: Chart of Accounts worksheet copied to CSV
What you get back
The result of that run, the rows to look at first.
Journal Entry ChecksSample data16 rows
| Journal entry ID | Account status | Balance status | Difference | Entry debits | Entry credits | Entry date | Line number | Journal account code | Journal account name | Debit | Credit | Chart account code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| je_2026_007 | Missing from chart | Balances | 0 | 875 | 875 | 2026-11-04 | 2 | 9,999 | Suspense | 0 | 875 | · |
| je_2026_008 | Exists in chart | Does not balance | 100 | 1,500 | 1,400 | 2026-11-08 | 1 | 1,000 | Cash | 1,500 | 0 | 1,000 |
| je_2026_008 | Exists in chart | Does not balance | 100 | 1,500 | 1,400 | 2026-11-08 | 2 | 4,000 | Service Revenue | 0 | 1,400 | 4,000 |
| je_2026_001 | Exists in chart | Balances | 0 | 1,250 | 1,250 | 2026-09-18 | 1 | 1,000 | Cash | 1,250 | 0 | 1,000 |
| je_2026_001 | Exists in chart | Balances | 0 | 1,250 | 1,250 | 2026-09-18 | 2 | 4,000 | Service Revenue | 0 | 1,250 | 4,000 |
| je_2026_002 | Exists in chart | Balances | 0 | 2,200 | 2,200 | 2026-09-26 | 1 | 5,100 | Office Rent | 2,200 | 0 | 5,100 |
| je_2026_002 | Exists in chart | Balances | 0 | 2,200 | 2,200 | 2026-09-26 | 2 | 2,000 | Accounts Payable | 0 | 2,200 | 2,000 |
| je_2026_003 | Exists in chart | Balances | 0 | 1,800 | 1,800 | 2026-10-03 | 1 | 1,200 | Accounts Receivable | 1,800 | 0 | 1,200 |
| je_2026_003 | Exists in chart | Balances | 0 | 1,800 | 1,800 | 2026-10-03 | 2 | 4,000 | Service Revenue | 0 | 1,800 | 4,000 |
| je_2026_004 | Exists in chart | Balances | 0 | 340 | 340 | 2026-10-11 | 1 | 6,100 | Software Subscriptions | 340 | 0 | 6,100 |
| je_2026_004 | Exists in chart | Balances | 0 | 340 | 340 | 2026-10-11 | 2 | 1,000 | Cash | 0 | 340 | 1,000 |
| je_2026_005 | Exists in chart | Balances | 0 | 960 | 960 | 2026-10-22 | 1 | 1,500 | Prepaid Insurance | 960 | 0 | 1,500 |
How do you check a journal entry template before upload?
Upload the Excel export of your journal entry template, then match the account names to your chart of accounts. The workflow checks that debits equal credits for each entry and that every account exists. It returns the journal entry checks and leaves unmatched rows for review.
How it works
How to use the Journal Entry Checks workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Journal Entry Checks: questions
What export should you use?
Use the Excel export of your journal entry spreadsheet. The workflow reads the exported file, not the source system.
What happens to rows that do not match?
Rows that do not match the chart of accounts or do not meet the balancing rule are flagged for review. They are not treated as valid journal entries until you fix them.
How do you change the rules?
You change the rules by editing the words that describe the check. For example, you can ask for different account matching or different row checks, then rerun the workflow.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent