If you currently use Quickbooks for your business accounting, you can use the Category Mapping feature in Rho to link your Rho card and Rho budget transactions to your QuickBooks accounts and balances (attribute).

To access Quickbooks Category Mapping, click the Integrations button from the Rho Toolbar. Then from the Integrations page click the Quickbooks Settings (gear) button and select Edit. Finally, from the Quickbooks page click the Edit button for the Category Mapping section.

From the Quickbooks Mapping page, you can do the following:

  • Map default Rho expenses and income to a Quickbooks attribute.
  • Map existing Rho budgets and cards to a Quickbooks attribute.

Once you have made updates to the Quickbooks Mapping page, click the Save and Edit button to return to the Integrations page.

Map default expenses and income

Rho transactions that are not assigned to a Rho budget, as well as Rho transactions that are assigned to a Rho budget or made by a Rho card that is not mapped can be assigned to a specific Quickbooks ledger. Rho allows you to specify one mapping for inbound transactions (Income) and one mapping for outbound transitions (Expenses).

Click the Default ledger for Expenses or Default ledger for Income drop-down list and select the desired Quickbooks ledger.

Map Specific Rho Budgets and Cards

You can assign any Rho Budget or Rho Card to a specific Quickbooks ledger

First, you map a Rho attribute (either Budgets or Cards) to a Quickbooks attribute (for example, map Budgets to Chart of Accounts, etc.). Then you create a rule within that mapping, that assigns a specific budget or card to a specific ledger for that attribute (for example, map Expenses to Accounts Payable).

Once a rule is created, you can create an additional rule for that mapping, or create an additional mapping (for example, map Cards to Vendors).

Creating a new mapping override

To create your first category mapping, click the Map Rho attributes drop-down list in the Mapping Override section, and select the desired Rho attribute, either Budgets or Cards. Then click the to Quickbooks attribute drop-down list and select the attribute to be mapped (for example, Chart of Accounts). An empty rule is automatically added to the map.

Once you have created a rule for your categories, the Rho application creates a new Mapping Override section allowing you to create a different mapping. For example, if you created a mapping between Budgets and Chart of Accounts, you can now create a second mapping between Cards and Chart of Accounts).

If you need to create a new mapping before creating a rule for your existing mapping, click the Add Override button.

Creating a new mapping rule

Once you have one or more overrides created, you can add a rule to a mapping category. First, if a rule has already been created for the map, click + New Rule to add an empty rule to the map. Then populate the rule with the Rho attribute by clicking the Select Attribute drop-down list for the and select the desired card or budget. Finally, populate the rule with the Quickbooks attribute by clicking the Select Attribute drop-down list and selecting the desired ledger.

When finished creating rules for this map, click the Save Rules button.

Once saved, all Rho transactions assigned to the selected budget or made with the Quickbooks transactions for that ledger are automatically reconciled in Quickbooks.

Did this answer your question?