To support Quickbooks Desktop customers, we have built an export format specifically for QBD (IIF format) that will make uploading transactions and reimbursements significantly easier than a CSV.
The fields that we can export data for are Chart of Accounts (Accounting Category), Customer, Vendor, Class and memo.
In order for IIF to work, you need to set up a few things in Ramp and QBD correctly for things to sync across seamlessly.
On Quickbooks Desktop:
- Setup a Ramp Card account of type Credit Card.
- Ensure that an Accounts Payable account (for use with reimbursements) is setup of type Accounts Payable.
- Ensure that a Bank Account (for use with reimbursements) is setup of type Bank Account
- Export list of fields to code on Ramp
- Go to File > Utilities > Export > Lists to IIF Files.
- Make sure Chart of Accounts is selected, along with the following if applicable: Customer List, Vendor List, and Class List.
- Press OK to export the IIF file.
You should have a Credit Card, Bank and Accounts Payable account in your chart of accounts (ctrl + A).
- If you’re using account numbers, make sure that the toggle for “Import Account Numbers” is green. Otherwise, make sure it is grey.
- Drop the IIF file exported from QBD into the setup screen and your accounting categories will populate. Then select your Ramp Card credit card account from the dropdown.
- If your accounting categories change on QBD, all you need to do is re-export all of the lists from QBD (File > Utilities > Export > Lists to IIF Files) and click “Import a new IIF File” at the bottom of the Accounting Settings > Manage Accounting Fields screen.
- Once you’ve uploaded everything, you can go into Accounting Settings > Default Accounts to set up your default A/P account and cash accounts for reimbursements.
Note: To import an IIF file, a user needs Administrator or External Accountant privileges within QBD. Thus any user that is managing this process that is not one of these roles needs to have permissions updated to be able to import successfully. For more information regarding permissions, please visit this article.
When an IIF is downloaded, it can be uploaded into Quickbooks From the Utilities Menu. (Tip: Backup the local QB company file first).
If you have any windows open, you will see this:
Clicking OK will close any open windows and open the IIF import dialog:
You can select a file to Import. The dialog only accepts files with an IIF extension.
In the above dialog, the IIF has been imported successfully. In this instance a list item has been successfully imported (in this case a vendor) and the transaction has been imported also.
The data shows up on the Bills screen as a Paid Transaction:
It shows up under Vendor Transactions:
Clicking on the transaction provides details of the split and the expense accounts it has been allocated to:
No categorization step is required on the QB side as this has been done on the Accounting tab in Ramp, and no separate import of vendors is required either.
Note: If you get an error message, QBD generates another IIF file with error messages for each of the failed imports. You can open up the file using excel to see what the underlying error is. When writing into support about a failed sync, please attach this file so that our team can efficiently debug the issue.
After the file is imported (steps above), please go to each Employee, open up a Bill and click "Pay Bills".
On this screen, select each bill, click "Set Credits", and then find the corresponding General Journal entry for the Bill:
Then click done. You will need to repeat this for each paid bill (QBD does not allow bulk actions).
Finally, click the "Pay Selected Bills" button, marking these as Checks. (You can either add them as "To be printed" or "Assign Check Number" - your preference.
You will receive this confirmation screen:
Then, you can click done, and the bills against those employees will be marked as paid.
Bill Pay for QBD is available! For more information, please reference this article.