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. |
metric |
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. |
metric |
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. |
metric |
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 |
The official name of the company whose financial data is being collected from QuickBooks. |
dimension |
Company ID |
Company ID |
A unique identifier assigned to the QuickBooks company file (realmId) from which the data is being retrieved. |
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. |
metric |
Report End Date |
Report End Date |
The end date of the reporting period for which the financial data is generated. |
dimension |
Report Start Date |
Report Start Date |
The beginning date of the reporting period for which the financial data is generated. |
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 |