Automated entry to accounting system for ACH reimbursement
We have recently begun using Expensify in our organization and we are utilizing the ACH reimbursement option for our employees. When the report gets approved it syncs with our accounting system (Intacct) and creates the entry for the employee payable. Is there a way that, once the reimbursement is processed, an automated entry is made to the accounting system to record the payment? Right now it looks like I would have to manually enter each employee's expense reimbursement. This will become quite cumbersome as our company grows.
Best Answer
-
Sheena Trepanier Expensify Team, Approved! Accountant, Expensify Student Ambassador Posts: 1,362 Expensify TeamHi @mfisher_CC1, welcome! Are you exporting your reimbursable expenses as vendor bills? If you are, the advanced option Sync reimbursed reports will sync any reports reimbursed with Expensify ACH to Sage Intacct and create a Bill Payment using the account selected.
You can learn more about this in our help center here.
Cheers!
Answers
-
Hello, where would we find the "Sync reimbursed reports" option? Or is it different when an account is sync'd to Quickbooks instead of Intacct? Thank you.
-
I am having the same issue. No entries booked after ACH processed.
-
Rachael Hopkins Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 904 Expensify TeamHi @Ellie_Ding you will want to check that Sync Reimbursed Reports is enabled on Settings > Policies > Group > [Policy Name] > Connections - Configure > Advanced.
If it is, send us an email to Concierge@expensify.com with the report IDs and we'll take a closer look!
-
Yes configuration is on for sync reimbursed reports. I emailed concierge back and forth for a day and still unsolved this issue
-
@Ellie_Ding Can you check your Time & Expenses configuration in Intacct to make sure you don't have payment approval enabled? This prevents us from being able to create payments.
-
I think that's the issue! But I can't find the way to disable it. Could you plz help?
TY
-
@Ellie_Ding Sorry! It's actually in your Accounts Payable module configuration under Payment Approval Settings.
-
weird because in AP module the bill approval setting is not turned on
-
@Ellie_DingI took a look at the logs for your account and actually noticed an issue with your configuration that may have been causing the problem. I synced your account after I fixed it and the sync did attempt to mark the reports as paid but we got an error that they have already been paid. Have you already manually created the bill payments? Do you have any reports that you could try to export to see if this is working correctly now?
-
I just tried to export one expense report now it worked! Is there a way I can reverse the previous exported expense reports?
-
@Ellie_DingYou would need to delete them from Intacct but you can definitely re-export them from Expensify and they should create the payments now.
-
Reexported and created duplicated expense reports. I tried to delete them from Intacct but got error messages.
Thank you very much! I have been chatting with the Concierage for days regarding this issue and you helped with the most progress so far!
-
@Ellie_Ding You're very welcome! If you go to Time & Expenses > Staff Expenses, you should be able to delete the reports directly rather than going through the batch summaries on the Journal list.
-
I found the way actually! I reversed the expense report from selected status of approved then deleted them from the staff expenses module.
-
Thanks!
-
Awesome @Ellie_Ding! Glad to hear it's been resolved! Let me know if you have any other questions!
