Skip to main content
August 13, 2020
Question

IMPORTING RAW DATA

  • August 13, 2020
  • 1 reply
  • 0 views

MY CUSTOMERS PAY ME BY DIRECT DEBIT - I USE A COLLECTION COMPANY CALLED LONDON AND ZURICH

 

THEY COLLECT AND PAY ME ONE LUMP SUM INTO THE BANK - SAY £10,000 - THIS MONEY ACTUALLY BREAKS DOWN TO 100 DIFFERENT CUSTOMER RECEIPTS

 

LONDON AND ZURICH PROVIDE A REPORT IN PDF OR CSV FORMAT

 

I WAS USING KASHFLOW AND I COULD IMPORT THE CSV AS A FILE AND IT RECORDED THE RECEIPT FOR EACH CUSTOMER IN A SECOND

 

HOW CAN I DO THIS IN QUICKBOOKS

1 reply

Fiat Lux - ASIA
August 13, 2020

You may need a 3rd party app to import Sales Receipt data.

RefNumberCustomerTxnDateShipDateShipMethodNameTrackingNumLocationClassBankAccountPaymentMethodPaymentRefNumberBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgCurrencyExchangeRateBillEmailToBePrintedToBeEmailedShipAmtShipItemTipAmtDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y MP3 PlayerBlue MP3 Player255  TAX
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Leather CaseLeather Case210  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y HandheldsPortable Game Player1100  TAX

 

https://transactionpro.grsm.io/qbo