Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
pmarcoux
Level 2

Upload Charge File to Quickbooks Enterprise 14

We are looking to use an upload file to create charge backs to customers on our Quickbooks Enterprise 14 and need some assistance on how to make this work and if there are embedded files already available

7 Comments 7
Chrea
Level 8

Upload Charge File to Quickbooks Enterprise 14

What file do you need to upload?

pmarcoux
Level 2

Upload Charge File to Quickbooks Enterprise 14

Hello Chrea - appreciate the response - that is what we are trying to figure out.

We have a set of ~100 charges from a different system that we need to load into Quickbooks to create invoices for those allotted customers based on the Customer ID's. If there is a file you would recommend we can test that process out - we are just not sure where to start.

Chrea
Level 8

Upload Charge File to Quickbooks Enterprise 14

You can prepare your invoice data in XLS or CSV file format with the following template

CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y15/09/2020John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              Non

 

then you can use TP Importer to proceed. It's a $199 one time license + you can get $100 cashback to purchase it through a partner.

https://get.transactionpro.com/qbd

 

AdonL
QuickBooks Team

Upload Charge File to Quickbooks Enterprise 14

Your inquiry about importing charge data from another system into QuickBooks is appreciated, Pmarcoux. I've got some information about this process.

 

QuickBooks Desktop Enterprise 14 doesn't have a direct option to upload file formats for chargebacks to customers and doesn't have pre-existing templates that could facilitate this process.

 

However, the program allows importing financial data (such as bank transactions, accountant's changes, and journal entries), bulk operations, and contact lists, depending on your file format. Here are some file formats you can use for the importing process:

 

 

For a comprehensive overview of importable items and formats you can use for this process, please refer to this resource: Import and export data in QBDT.

 

Alternatively, you can check out the Intuit Marketplace to see apps that can help you and start the process of importing this data and creating invoices.

 

You're always welcome to post here in the Community forum if you have any other concerns about importing transactions to QBDT. We're always available for you.

pmarcoux
Level 2

Upload Charge File to Quickbooks Enterprise 14

Chrea - thank you again, would this work with Quickbooks Enterprise Desktop?

Chrea
Level 8

Upload Charge File to Quickbooks Enterprise 14

@pmarcoux 

Yes. Check the importer tool as I mentioned earlier. If your company is in the US, you can get it for free from a partner. T&C apply.

pmarcoux
Level 2

Upload Charge File to Quickbooks Enterprise 14

Thank you AdonL - will be testing out the other provided option for import tool.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us