Fiat Lux - ASIA
Level 15

Transactions

@robustianotubio 

Prepare the the data with the following template

 

Bills

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples 01/10/202015/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
101 Staples 01/10/202015/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
185 Green's Taxi Service 01/10/2020 Net 30 1 Main Street   San DiegoCA12345    Transportation 125.13           

 

Bill Payments

RefNumberAPAccountVendorTxnDateBank or CC AccountPrivateNoteCurrencyExchangeRateToBePrintedBillApplyToLineAmount
2001 Staples01/11/2020CheckingBill Payment  N101375.53
3454 Green's Taxi Service01/11/2020CheckingBill Payment  N185125.13
321901 Federal Express01/11/2020CheckingBill Payment  N201

264.07

 

 

Then you are able to import the data by TPImporter