Month-end spend check
By Toolspoke
Matches a month of Ramp card spend against the bills recorded in QuickBooks and lists every difference with a reason.
Needs a Toolspoke account. You choose which project it installs into.
Ramp
QuickBooks Online
Its last step
Write the summary
- Ramp + QuickBooks Online
- Required integrations
- Runs when you ask
- No schedule of its own
- Write the summary
- What its last step does
- Nothing destructive
- 0 of 22 actions in its tools
On this page
The short version
- What it is
- Matches a month of Ramp card spend against the bills recorded in QuickBooks and lists every difference with a reason.
- Works with
- Ramp, QuickBooks Online
- How often
- When you ask it to.
- What it never does
- Create, edit, categorise or delete anything in QuickBooks or Ramp.
- What you need
- A Toolspoke account, with Ramp and QuickBooks Online connected.
How it works
What each run does, from the "Steps" part of its own instructions.
- Step 1:
Fix the period the calendar month asked for. If none was given, use the last complete month and say so. Use the same dates in both systems.
- Step 2:
Pull both sides
Ramp transactions and reimbursements for the month, and the QuickBooks bills and expenses for the same month.
- Step 3:
Match on amount and date, then on merchant or vendor
Allow a few days' difference in date. Card transactions often settle after the day they were made.
- Step 4:
List the exceptions in groups
In Ramp, not in QuickBooks: usually a missing receipt or an uncategorised transaction. Name the cardholder. In QuickBooks, not in Ramp: paid another way, or recorded twice. Possible duplicates: the same amount to the same merchant within a few days. New...
- Step 5:
Look at the ten largest items
, matched or not. A large charge that reconciles perfectly can still be wrong.
- Step 6:
Write the summary total spend, the change from last month with a reason for any large part of it, and the exception list with an owner and a next step for each row.
What you get
How the agent's own instructions describe what it hands back. Install it to see a real result.
Write the summary total spend, the change from last month with a reason for any large part of it, and the exception list with an owner and a next step for each row.
Integrations & requirements
Month-end spend check needs Ramp and QuickBooks Online to work. You sign in to each one yourself.
Ramp
RequiredRead card transactions, cards, people, departments, locations, reimbursements, bills, and spend limits.
Authentication: Ramp API client credentials
QuickBooks Online
RequiredRead a QuickBooks company: invoices, bills, customers, vendors, the chart of accounts, and the two headline reports.
Authentication: Sign in with Intuit
Skills it follows
| Tool | Actions it offers |
|---|---|
| Ramp | 12 in all: 12 read, 0 write, 0 destructive. Nothing that deletes or permanently changes anything. |
| QuickBooks Online | 10 in all: 10 read, 0 write, 0 destructive. Nothing that deletes or permanently changes anything. |
A project can switch any action off, and every call is logged. The counts are what each tool offers; which of them the agent uses is up to its instructions.
What it will never do
- Create, edit, categorise or delete anything in QuickBooks or Ramp.
- Lock, cancel or change a card or a spend limit.
If something goes wrong
This check sees the card platform and the books, not the bank. Say that at the top of the summary, so nobody reads it as a full bank reconciliation. If either side cannot be read, stop and say which. Half a reconciliation reads as a clean one.
These are written into Month-end spend check's instructions. They guide the agent, but they are not a permission. What it is allowed to touch is set by the access you grant.
When it runs
Month-end spend check has no schedule. It runs when you ask it to.
Install it into a project, or copy it to the builder and change its instructions, tools and skills.
Use Month-end spend check
Pick a project and connect the tools it needs.