If your organization operates in services or construction and uses Products/Services in QuickBooks Online to track costs and generate Job Costing Reports, you can import these items into Fyle to streamline expense categorization. Since Items are linked to Expense and Income Accounts, tracking expenses in Fyle by Item ensures accurate job cost reports and simplifies rebilling customers by tying expenses directly to invoices.
Importing Products/Services from QuickBooks Online to Fyle
To import Products/Services from QuickBooks Online into Fyle:
Log in to Fyle – QuickBooks Online Integration.
Navigate to Dashboard > Import Settings.
Enable Import Products/Services from QuickBooks Online.
Save the settings.
Once enabled, all active Products/Services from QuickBooks Online will be imported as Categories in Fyle. Employees can then tag expenses to these items for accurate tracking.
Exporting Expenses to Item Details in QuickBooks Online
Since both Chart of Accounts and Products/Services can be imported as Categories in Fyle, the integration ensures that expenses are correctly categorized in QuickBooks Online:
If an expense is categorized as a Product/Service Item in Fyle, it is exported to the Item Details section in QuickBooks Online (under Expense/Bills or Credit Card Charges, depending on your configuration).
If an expense is categorized under a Chart of Accounts item (e.g., a Food expense account), it is exported to the Category Details section instead.
This automated mapping ensures that expenses are posted to the appropriate section in QuickBooks Online.
For example, in the below screenshot, the expense was created by the integration and the expense is posted to the item Installation Service
Important Considerations
Journal Entry Export Limitation: The option to import Products/Services will not be available if Journal Entry is selected as the export transaction type for reimbursable or corporate card expenses.
Using Items for All Expenses: If your organization primarily uses Items for expenses and they are tagged to an expense account by default, it’s recommended to import only Products/Services, instead of both Chart of Accounts and Products/Services.
Disabled Items Sync: If a Product/Service is disabled in QuickBooks Online, it will also be disabled in Fyle.
Impact of Changing Export Type: If Products/Services were previously imported but the export type is later changed to Journal Entry, all imported Products/Services will be disabled in Fyle since Journal Entries do not support exporting expenses as Items.
Do reach out to us at [email protected] if you need any assistance setting this up.