How do you divide one charge among multiple classes/properties in the same transaction?
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
-
@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.
Answers
-
Sheena Trepanier Expensify Team, Approved! Accountant, Expensify Student Ambassador Posts: 1,362 Expensify Team@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.
Cheers!
-
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 Trepanier Expensify Team, Approved! Accountant, Expensify Student Ambassador Posts: 1,362 Expensify Team
Thank you for the insight @JenRoto, it's very helpful and I truly appreciate you taking the time to share you thoughts here.
-
It should not be hard to have these split transactions import as line items in one QB transaction instead of separate transactions.
-
@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.
