Currently when we close a report and export the total amount of the expenses come across on the date the report is submitted. I want the the individual expenses to reflect on the date of purchase.
The export function reads the reimbursable status of the expense to determine which export settings to abide by. So, for non-reimbursable expenses you can set them as Credit Card Transactions even if they are really from a debit card. Non-reimbursable expenses will post with the expense/transaction date individually.
Reimbursable cash transactions, unfortunately, can't post with individual expense dates. The closest option you get is Date Of Last Expense. This is a limitation of the integration we cannot get around currently.
I hope this helps! Please let me know if you have more questions.
Hi @JB_5062, welcome to the Community. Can you let us know if your QuickBooks Desktop or QuickBooks Online connected in Expensify? Also, are you referring to reimbursable or non-reimbursable expenses?
I am referring to both reimbursable and non-reimbursable. It is connected, we export the reports via QuickBooks desktop.
@JB_5062 When exporting to QuickBooks Desktop as a vendor bill, check, debit card, or journal entry, we use the date selected in your configuration. You can edit this date to either Date of Last Expense or Exported Date by going to Settings > Policies > [policy name] > Connections > Configure.
The only option that uses the date of each expense is the non-reimbursable credit card export because we send each expense as an individual credit card transaction. Let me know if you have any questions!
If we use a debit card can we still select the credit card option as we want the transaction to reflect the date it was incurred? How do we handle cash transactions so they import into the accounts on the date they were incurred?