Quickbooks: Most-used fields#
The table below gives information about most-used fields that you can import from Quickbooks. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Adverity UI name |
Description |
Use in Adverity |
|---|---|---|---|
1 - 30 |
1 - 30 |
Represents the total amount of outstanding receivables that are 1 to 30 days past their due date, as reported in the Accounts Receivable Aging Summary. |
dimension |
31 - 60 |
31 - 60 |
Represents the total amount of outstanding receivables that are 31 to 60 days past their due date, as reported in the Accounts Receivable Aging Summary. |
dimension |
61 - 90 |
61 - 90 |
Represents the total amount of outstanding receivables that are 61 to 90 days past their due date, as reported in the Accounts Receivable Aging Summary. |
dimension |
91 and over |
91 and over |
Represents the total amount of outstanding receivables that are 91 days or more past their due date, as reported in the Accounts Receivable Aging Summary. |
metric |
Account Description |
Account Description |
Provides the descriptive name of an account, such as ‘Sales Revenue’ or ‘Rent Expense’, as it appears in financial reports like the Profit and Loss or Balance Sheet. |
dimension |
Company |
Company |
Represents the QuickBooks Online company whose financial data is being accessed. This field often refers to general business information available through the CompanyInfo entity. |
dimension |
Company ID |
Company ID |
A unique identifier (realmId) assigned by QuickBooks to a specific company’s account. This ID is essential for all API requests to specify which company’s data is being accessed. |
metric |
Current |
Current |
Represents the total amount of outstanding receivables that are not yet past their due date, as reported in the Accounts Receivable Aging Summary. |
dimension |
Report End Date |
Report End Date |
The end date for the financial report period. This parameter is used when requesting specific reports like Profit and Loss, Balance Sheet, or AR Aging Summary to define the reporting timeframe. |
dimension |
Report Start Date |
Report Start Date |
The start date for the financial report period. This parameter is used when requesting specific reports like Profit and Loss, Balance Sheet, or AR Aging Summary to define the reporting timeframe. |
dimension |
Total |
Total |
The cumulative sum of amounts for a specific section or an entire report, such as the total income or total expenses in a Profit and Loss report. |
metric |