We are currently experiencing higher than normal support inquiries and response times. The Community is here to support you as well so please help each other out when you can. Please visit our status page to subscribe to updates.

How do you divide one charge among multiple classes/properties in the same transaction?

nicoleseagonicoleseago Expensify NewcomerPosts: 6Expensify Customer Expensify Newcomer

Does Expensify allow the users to divide ONE expense into several different categories when it is ONE charge on the credit card statement? We were utilizing the "Split" option when entering a receipt, but found that it exports to QB line by line, rather than charge by charge, when we use the Split line. This would be helpful for orders that ship separately, causing one receipt to have multiple charges. Generally though, we have one receipt with items that need to be allocated to different venues. Do you have anything that could be helpful in this situation?

I originally emailed this question to Katie from Expensify, and she unfortunately told me that this isn't an option right now, but will be considered. Would this be something helpful for other companies? It would make reconciliation from Quickbooks to our credit card statement much simpler!

Best Answer

  • tylerzolltylerzoll Expensify Champion Posts: 437 Expensify Champion
    Accepted Answer

    @nicoleseago, I assume that you are using a direct connection with your credit card to Expensify. If you are doing that, then you can go to the loading dock and download the reconciliation report there. This works because the expense becomes two lines on the report and it has the original amount and the split amount. This way you can reconcile much easier. Just download the Reconciliation excel spreadsheet and you'll be set.


  • Sheena TrepanierSheena Trepanier Expensify Success Coach Posts: 1,992Expensify Success Coach - Admin Expensify Success Coach

    @nicoleseago -- Katie was correct in that this functionality isn't really supported well if you need to export those split expenses to your accounting package. Since this isn't supported now and isn't on our immediate roadmap I'd recommend adding this to our Ideas category on the forum.

    Ideas shared on the forum in this category give other users the chance to vote on their ones they'd like to see built out, since the most popular ideas will be reviewed by our team and have a real chance of being placed on our roadmap.

    You can share your idea quickly here.


  • JenRotoJenRoto Expensify Newcomer Posts: 5Expensify Customer Expensify Newcomer

    You cannot use the reconciliation Expensify report to reconcile these split transactions, if you are reconciling QB. It must be done in QB. That Expensify report is useful to see whether expenses have been imported or not, but you still have a lot of work determining which split charges go with which charge if you don't reconcile right away by ending and starting balances (which they never do)...thus trying to figure out where these charges go. It is a pain.

  • Sheena TrepanierSheena Trepanier Expensify Success Coach Posts: 1,992Expensify Success Coach - Admin Expensify Success Coach

    Thank you for the insight @JenRoto, it's very helpful and I truly appreciate you taking the time to share you thoughts here.

  • JenRotoJenRoto Expensify Newcomer Posts: 5Expensify Customer Expensify Newcomer

    It should not be hard to have these split transactions import as line items in one QB transaction instead of separate transactions.

  • Nicole TrepanierNicole Trepanier Expensify Success Coach Posts: 699Expensify Success Coach - Admin Expensify Success Coach

    @JenRoto When exporting to QuickBooks Online as credit card transaction, we do put the split transaction back together to make one non-reimbursable credit card expense in QuickBooks. QuickBooks Desktop does not have this feature.

Sign In or Register to comment.