Deep Dive: Using Expense Rules to vendor match when exporting to an accounting package
When an exact match is not available, "Credit Card Misc." is used to prevent multiple variations of the same vendor (e.g. Starbucks and Starbucks #1234, as is often seen in credit card statements) from being created in your accounting package.
To have a different vendor listed, you can change the merchant name in Expensify to be an exact match to the appropriate vendor entry in the accounting package.
- For repeated expenses, the best practice is to use Expense Rules, which will automatically update the merchant name without having to do it manually each time.
This only works for connections to QuickBooks Online, Desktop, and Xero. Vendor matching cannot be performed in this manner for NetSuite or Sage Intacct due to limitations in the API of the accounting package.
Setting up an expense rule for repeat merchants will provide time-saving benefits of automation, ensuring the merchant name matches and expense coding is started.