Skip to main content
August 2, 2020
Question

Changing non-taxable to taxable

  • August 2, 2020
  • 1 reply
  • 0 views

Hi,

 

How can I make a tax that was "non-taxable" that should have been marked "taxable" and has about 1500 transactions on it already? 

 

Thanks,

1 reply

Fiat Lux - ASIA
August 2, 2020

Which transaction type (e.g Invoice, Sales Receipt)? You may need a 3rd party tool to do so.

August 2, 2020

We put the tax code on our invoices and credits for vendors as well. Any way intuit can edit the source code of the file to edit it ? 

Fiat Lux - ASIA
August 2, 2020

You can export the data out to XLS, modify  them, and reimport back into the company file.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template should be like these

 

Invoices

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 CodeItemQuantityD escriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100    Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y#########John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              Non

 

There is no tax field in Vendor Credit

VendorTransaction DateRefNumberMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableAP AccountCurrencyExchange Rate
Bell Telephone01/09/2020891Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Delivery Charge15Refund Delivery Charge             
Bell Telephone01/09/2020891Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA       Overhead1Overhead Costs100      
Ajax Lumber02/09/2020892 Ajax Lumber200 Smith Street  AnytownNY11111USA Late Fee10Refund Late Fee