x

Start now

Schedule a demo

  • Date Format: MM slash DD slash YYYY
  • This field is for validation purposes and should be left unchanged.
Field Mapping–Open AP Aging – OneSource: Inventory for QuickBooks Online Field Mapping–Open AP Aging – OneSource: Inventory for QuickBooks Online

Have a Question?

Field Mapping–Open AP Aging

You are here:
< All Topics

Field Mapping Notes (for the OneSource Field Mapping Spreadsheet – AP Aging file)

Field Mapping Spreadsheet

Column Name

OneSource

Field Type

Field length or Numeric Range Sample Values Default Value

Additional Notes

           
Bill ID Long Integer (Auto Number) Between -2,000,000,000 and 2,000,000,000 12345678 (Will be auto generated by OneSource if left empty) This is the unique identifier (Primary Key) for the AP Bill.
Supplier Number Text 50 12345 or ABC12345   *** REQUIRED *** This is the unique Supplier Number of the Supplier or Vendor you intend to pay. If Supplier Numbers will be regenerated when the data is imported, this will need to be the new Supplier Number generated by OneSource.
Amount Currency 15 $100.00 $0.00 *** REQUIRED *** This is the unique Supplier Number of the Supplier or Vendor you intend to pay. If Supplier Numbers will be regenerated when the data is imported, this will need to be the new Supplier Number generated by OneSource.
Purchase Order Number Text 50 12345 or ABC12345    
Invoice Number Text 20 12345 or ABC12345    
Account ID Long Integer + or – 2,000,000,000 123456 (The OneSource GL Account ID will be used here) Note: In order to keep the GL Balance with the Beginning Balance Journal Entry, this account will be set to the GL ID of the OneSource Accounts Payable GL account.  No GL Account is necessary here.
Invoice Date Date Short Date 8/01/07 Import Date  
Due Date Date NA 8/01/07 Import Date  
Terms Text 50 1% 10 Net 30 Unknown  
Purpose of Expense Text 50 Needed a company car   Internal notes about this expense.
Comments Text 255 For x item.   Comments printed on AP Check.
Discount Taken Currency 15 $30.00 $0.00 When the Bill is later paid, this amount will be subtracted off of the amount paid for the Bill for paying bills early.
Tax Deductible Yes/No Yes / No

-1 / 0

No No  
1099 Yes/No Yes / No

-1 / 0

Yes No Do you want this Bill to be included on year-end 1099’s?
Items Received Yes/No Yes / No

-1 / 0

Yes Yes Have the items for this bill been received yet?
           

Previous Field Mapping–Inventory Item List
Next Field Mapping–Open Purchase Orders
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents