Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Is there a way for QBO to format the feed from Certify? It comes through with too much-unneeded info.

We use Certify for employee expense reporting. Because we reimburse by ACH the feed from Certify comes through as a journal entry with too much-unneeded information.
2 Comments
QuickBooks Team

Is there a way for QBO to format the feed from Certify? It comes through with too much-unneeded info.

Hello there, @adavis2.

 

Let me share some information on how you can manage your downloaded expense transactions.

 

To start with, the data downloaded in your QuickBooks account depends on the information Certify shares with us. Modifying it is currently not available. However, you need not worry, you can download your transactions from Certify and import it to QuickBooks. Just make sure that the it follows the required format. 

Once completed, you can start importing your transactions. Now, you can manually review each employee expense and assign the appropriate category.    

 

Also, I've added these articles to help you manage your downloaded bank transactions:

Know that the Community and I are always here to help if you have other questions about managing your transactions. 

Level 15

Is there a way for QBO to format the feed from Certify? It comes through with too much-unneeded info.

@adavis2 

If you don't mind to work manually, you may prepare the JE data in XLS and utilize an importer tool

https:// transactionpro.grsm.io/qbo

 

The template should be like this

RefNumberTxnDatePrivateNoteIsAdjustmentCurrencyExchangeRateAccountLineAmountLineDescEntityClassLocation
10101/10/2020Wire TransferFALSE  Savings-50,00Credit Savings   
10101/10/2020Wire TransferFALSE  Checking50,00Debit Checking   
10201/10/2020Wire TransferFALSE  Savings200,00Debit Savings   
10201/10/2020Wire TransferFALSE  Checking-200,00Credit Checking   

 

Need to get in touch?

Contact us