The Accounting page allows Admin and Bookkeeper users to view credit and debit card transaction history within your business, as well as determine at a high level which transactions are missing categorization before closing out their monthly books.
This can be done by filtering for Category, Date, or ‘Uncategorized’ near the upper right hand side.
Admin and bookkeeper users will be able to sync the expense records directly to Xero, QuickBooks Online, or NetSuite. If you aren’t connected to one of these accounting softwares, you may also export transactions (including categories) in CSV form to be uploaded to accounting software of your choice.
Categorizing transactions
We've partnered with Spade, a third-party aggregator of merchant processing data, to enable Mercury to automatically categorize card-based transactions made within the US.
Spade will automatically assign one of 40 pre-made Mercury categories to transactions that fit this criteria. In the event that we get it wrong, you can re-categorize any transaction from either the Accounting or Transactions page.
Furthermore, if you have integrated your Mercury account with one of our partners like Xero, QuickBooks Online, or NetSuite you'll be able to select a General Ledger (GL) code for each transaction prior to syncing.
Automating categorization
You are able to create custom rules to automatically assign GL codes to card transactions based on the Mercury category and/or the merchant. You will be prompted to set up these rules when you first integrate your accounting software with Mercury. You can also update or edit these rules at any time by navigating to the Accounting page and selecting the gear icon in the top right.
Once a mapping rule is set, any future card transactions that meet the mapping criteria will be updated with the appropriate GL code automatically.
Adding or editing categories as a non-admin or bookkeeper
If you are a Card Only or Custom user in Mercury, you will not have access to the Accounting page. However, you will be able to edit the categories for transactions you’ve made directly in the Transactions page.
To do so, select a transaction to the category (if any) automatically assigned. If the transaction requires categorization you can edit or add one via the Transactions Details panel that appears on the right side of the page when selecting transactions.
Frequently asked questions
What does it cost to sync transaction details on the Accounting page to my accounting software?
QuickBooks and Xero enriched automations, as well as the ability to import bank feed connections across QuickBooks, Xero, and NetSuite, are free. If you want to use our enriched NetSuite accounting integrations and automations to sync your card transactions to NetSuite, you’ll want to upgrade to a paid plan. Other IO card features are still free to use.
Learn more about pricing here.
What type of transactions can be mapped, categorized, and synced from the Accounting page?
This accounting page is currently for credit (IO) and debit card transactions only.
If I create a mapping rule, will it impact past transactions?
Not necessarily. Mapping rules will generally only impact transactions that come through after the rule has been created. However, manually updating the Mercury Category on a past transaction will trigger the mapping engine to run and update the GL code if applicable.
How can I tell if a mapping rule has been applied to a transaction?
When a mapping rule has been applied you will see a sparkles icon next to the GL code.
What happens when I nudge a cardholder?
When you nudge a cardholder via the action column, the cardholder will receive an email reminding them to update the transaction with any required information that is missing, specifically a receipt and/or Mercury Category.