Skip to main content
K
KStambaugh
January 2, 2024
Question

ERP and Accounts Receivable

  • January 2, 2024
  • 3 replies
  • 0 views

My company uses an ERP system called Epicor/BisTrack.  This system manages all Inventory and AR transactions via journal entry upload.

 

When this system went live, I was told by the implementation team to create a second AR account under Other Current Assets; then credit each open invoice in the AR account in QBO to move open invoices to the new account on the Balance Sheet so that the QBO AR account is $0.00.  All AR is housed within Epicor/Bistrack.

 

We have decided to terminate our contract with Epicor/BisTrack and now I am trying to figure out how to get our open AR out of the Epicor AR account and back into the Accounts Receivable (A/R) account on the balance sheet.  The problem is, I need the AR transactions to age correctly for our Line of Credit with the bank and I don't want to affect COGS as it has all been accounted for.

 

Any suggestions??

 

Thank you!

3 replies

Rainflurry
Rainflurry
January 2, 2024

@KStambaugh 

 

Just to confirm, you have an Other Current Asset account in QBO that matches your A/R total in your ERP system, correct?  And, when you moved to the ERP system, did you create the offsetting A/R credits and close out all of the open invoices in QBO?  I just want to confirm you're starting with a clean slate. 

 

How many open invoices are we talking about?  To have A/R age properly, you will need to get the invoices imported into QBO.  I don't know of any way around that.  You can use the import function in QBO to import them if you can get the required data out of your ERP system.  Go to Settings > Import data > Invoices and download the sample CSV file so you have the template.  You also need to have all of the items set up in QBO that are on the invoices but you can download the template for that also.  If that seems overwhelming, you may need to look at a 3rd party importer tool like Transaction Pro.         

K
KStambaughAuthor
January 4, 2024

Thank you so much for the suggestion!  I'll look into it and hopefully the import will work

D
deco1313
February 22, 2024

Hi KStambaugh,

Would love to chat with you about your experience using BizTrack and QBO. We are currently using Great Plains and want to switch to QBO but want more information about exactly what this looks like from someone who has first hand knowledge. Also, would love to know what ERP your company switched to from Biztrack. Not sure if there is a away to DM other quickbooks users or send a secure message to you.

4
4Gal
February 23, 2024

@deco1313 

Are you running a manufacturing company?

D
deco1313
February 23, 2024

@4Gal We do some custom manufacturing, but mostly sales of already manufactured windows and doors.

W
WSDPSD
February 23, 2024

Hello KStambaugh,

 

My Company also uses BisTrack.  We are currently using MS Dynamics GP, but would like to switch back to QuickBooks.  Would you mind if I contacted you for a conversation to pick your brain and discuss the pros and cons of your experience?

~Fayth

Terms & ConditionsAccessibility statement