How to import Billing Rates into QuickBooks

You can import billing rates level list into QuickBooks from text or Excel files using Zed Axis by following these steps:
  1. Open Zed Axis and connect to the QuickBooks company file you want to import the billing rates level list into.
  2. Browse to the file that contains the billing rates lists,
  3. Create a mapping of the columns in your import file to the corresponding fields in QuickBooks
  4. Click Import and Axis will import the lists in batch into your QuickBooks desktop company file.

Below is a description of the fields that you can map when import Billing Rate level lists:

Import billing rates into QuickBooks

QuickBooks fieldTypeDescription
Billing Rate NameStr 31Name of the billing rate as it appears in QuickBooks
Item Full NameStrFull name of the service item 
Custom RatePriceThe price of the item for the billing rate (do not map item uses a Percent rate)
Custom Rate PercentPercentThe percent rate for the item for the billing rate (only use if the service is priced as a percent)
Adjust PercentPercentThe percentage to adjust the items price (if mapped you must also map Adjust Relative To)
Adjust Relative ToBoolSpecifies the service item rate that AdjustPercentage is applied to. Normally, this is set to StandardRate.(values: StandardRate, CurrentCustomRate)