Improve Company Card Reconciliation Settlements report

ToJensen

SUGGESTION...I manually enter Credit Card purchases each month into QuickBooks by first downloading the 'Reconciliation' 'Settlements' CSV file. It would be extremely helpful if you would include in that 'Settlements' report the Expense Category to which it gets charged. That would eliminate the need of researching each user's monthly purchase statement to search for that information. Thanks for your consideration.

Rachael Hopkins

Hi @ToJensen Welcome to the Expensify Community!

Is there a reason you don't have Expensify connected directly to QuickBooks? You shouldn't need to manually enter anything.

Are you using QuickBooks Online or QuickBooks Desktop? There is actually an automated reconciliation process for QBO.

Christina Dobryzynski

Thanks for reaching out @ToJensen! We do have an option to connect QuickBooks Online to your group policies and auto-reconcile the Expensify Card's in QuickBooks Online.

Here's a support article about how the auto-reconciliation process works. Do you think this would work as another option to your current workflow?

Svillanueva

@Rachael Hopkins is there an automated reconciliation process for QB Desktop?

Sonia Liapounova

Hi @Svillanueva 👋

We do have a connection with QuickBooks Desktop. Take a look at this help page for and overview and instructions on how to connect!

Svillanueva

@Sonia Liapounova we already made the connection. My question was if there is automated reconciliation. Another rep responded to me and said that auto rec is not available for QuickBooks Desktop.

Sonia Liapounova

@Svillanueva Got it! That is correct, we do not have auto reconciliation with QuickBooks Desktop. Due to the nature of QuickBooks Desktop being a desktop app rather than a cloud based app it's not possible for us to build auto reconciliation into the connection.