FreshBooks offers cloud-based accounting software designed for service-based small businesses. FreshBooks features include time tracking, expense tracking, and invoicing.
Our integration with FreshBooks syncs detailed payroll expenses into your FreshBooks account. No need to manually transcribe payroll expenses — let Gusto help! You can create additional levels of granularity within FreshBooks based on expense type and Gusto departments.
Option 1: Connect to FreshBooks from Gusto
You’ll need admin permissions in both Gusto and FreshBooks to connect your accounts. Start here:
Option 2: Start a new Gusto account from FreshBooks
If your company does not have a Gusto account yet, follow these steps to sign up for Gusto with 2 months of free payroll.
Automating your mappings is optional but recommended to avoid sync errors. This lets you pre-select which FreshBooks accounts should be used by default for new payroll categories. This means that when a new item is created in Gusto, you will not need to manually map it—Gusto will automatically apply your default mapping.
You’ll manage automated mappings in the Default tab. Click here for more details and next steps.
In the Settings section of the integration, stay on the Manage tab to set up any additional sync preferences—such as whether the sync runs automatically or manually, or whether certain taxes should be consolidated.
Head to the section below for a description of each setting and how to set them up.
Below is each setting you can customize and how to do so.
Here’s how to get to any of these settings:
Contractor payment sync
If you pay contractors through Gusto, decide how those payments should sync:
Employer tax consolidation
Choose how you want employer taxes to appear in FreshBooks:
Journal entry consolidation
By default, Gusto consolidates entries of the same type into a single journal entry. You can also choose to group entries:
Click here to learn more about group mappings.
Entry date options
Select when the journal entry should appear in FreshBooks:
Here’s why mapping your chart of accounts matters:
Map your chart of accounts
Time-saving tips for the Mapping tab:
Why default mappings matter
Over time, you may make changes to your Gusto account such as adding a custom deduction, creating a new earnings type, or setting up a new benefit. When this happens, new payroll line items are created in Gusto that need to be mapped to an account in FreshBooks. If these items are not mapped, they can cause sync issues. Setting up default mappings can help you with this.
What default mappings do
Default mappings let you pre-select the FreshBooks accounts that should be used for new payroll categories. This means that when you create a new line item, you will not have to manually map it to a FreshBooks account—Gusto will automatically apply your default mapping to it.
Setting up default mappings is optional. If you prefer to manually map new Gusto categories, simply leave the default mapping blank.
Set up default mappings
Follow these steps to set up or change default mappings:
Edit default mappings
You can change default mappings at any time in the Default tab. Changes will only apply to new mappings going forward.
Edit detailed mappings
If a new category has been given a default mapping you’d like to change, you can change it in the Detailed tab. Here's how:
If past payrolls have already been synced to FreshBooks with an incorrect mapping, you’ll need to manually re-sync those payrolls.
To provide more granularity, you have the option to map your chart of accounts by employee, job, department, or Gusto Projects (available to companies using Gusto Project Tracking).
This is optional.
Step 1: Choose your journal entry consolidation method
Step 2: Set up mapping overrides
Once you select a consolidation method, a new tab appears on the left. Ex: If you choose to consolidate by employee, the tab will be called Employee. If you choose to consolidate by department, the tab will be called Department.
You can override default mappings for individual employees, departments, jobs, or projects. Overriding a default mapping means assigning different accounts to payroll items at these levels.
This is optional—if no overrides are applied, journal entries will still be categorized accordingly.
Here's how to set up an override:
Contractor payments
Consolidating journal entries by employee and department is compatible with contractors.
Consolidating by job and project is not compatible with contractors. This is because job titles and Gusto Projects are not currently supported for contractor profiles. If your company pays contractors and uses job or project consolidation, contractor payments will be synced based on the default company mappings.
The individual payroll expenses will post to "Expenses" in FreshBooks under 3 expense entries (total wages, total taxes, and total reimbursements). Contractor payments are listed separately. The name of the contractor is included and there's no need to approve the expense.
When using an accounting software, there are two ways to reconcile and match expenses with withdrawals from the bank account.
Pull up the bank transactions from your integration with your bank account. When you see a withdrawal, create a corresponding expense.
Example: You bought a few items at the office supply store, and therefore see this bank withdrawal when looking at your bank transactions. You can now add a corresponding office supply expense for reporting purposes. The expense is now accounted for as demonstrated by the reduction in cash.
Report a future expense. When you see the actual cash transactions, match the cash withdrawal with the expense that was previously reported.
Example: You forecast that supplies will cost $X amount of money at the beginning of the month, but the funds will not be withdrawn until the end of the month. You therefore report the expense. When the cash is withdrawn at the end of the month, you can indicate that the previously reported expense matches with this specific bank transaction.
When generating paper checks using your accounting software you may see an additional expense created on your books - this is because total gross wages are reported whether your employees were paid by direct deposit or by check.
This can cause issues when reconciling your expenses because the amount paid to employees may appear to be over-reported.
Our preferred method is for you to print the checks from your Gusto account or handwrite them to avoid expenses appearing as over-reported. Then, you can easily reconcile the total payroll expense from Gusto when the checks are cashed by your employees.
If you are not handwriting or printing your checks through Gusto, below are the best options to avoid over reporting.
Example of over-reported checks
You run a payroll that costs $10,000, where your employee is receiving a $7,000 check from you. In the $10,000 expense synced over from Gusto, you can see line items for $9,000 of gross wages (this includes a $7,000 check + $2,000 in employee taxes) and $1,000 of employer payroll taxes.
When you create a check for your employee in your accounting software, it will also create an expense for $7,000. As a result, when you look at your total payroll expenses you will now see that payroll for this pay period costs $17,000. When reconciling your books, however, only $10,000 will be taken from your checking account ($3,000 for employee + employer taxes and $7,000 from the cashed check).
The check created by your accounting software has led you to over report your payroll expenses, so when you look at your profit for the year it is lower than it should be. You will need to use one of the solutions described below to reconcile the over reported check payment.
Steps to reconcile checks
Reduce the expense account associated with Gross Wages, indicated by your mappings in Gusto, by the amount of the employees' check prior to creating the check in your FreshBooks account. Reducing the Gross Wage expense by the check amount will prevent double counting.
Example: You sync over a total payroll expense of $10,000. Knowing that creating a check will over-report the expense by $7,000, you reduce the gross wage expense from $9,000 to $2,000.
How to edit a Gusto FreshBooks expense
FreshBooks does not support liabilities. Handle your benefit expenses directly in FreshBooks.
Choose a section below for frequently asked questions about this integration.
Q: The chart of accounts in Gusto does not look correct. What should I do?
A: First, click Refresh chart of accounts in Gusto. If this does not resolve the issue, you may have linked the wrong FreshBooks account. Disconnect the integration and reconnect to the correct FreshBooks account.
Q: How do I handle checks?
A: We recommend printing checks from your Gusto account or handwriting them. You can then reconcile the journal entry from Gusto when your employees cash the checks. We do incorporate the amount of each check in our Journal entry.
Q: Why can’t I find the FreshBooks account I’m looking for in the drop-down?
A: The initial list in the drop-down menu shows recommended accounts based on the selected category. To choose a different account, simply type the name of the account into the search box.
If you still cannot find the account, it may need to be created in FreshBooks first. Once you’ve created the account, click Refresh Chart of Accounts and try searching for it again in the search box.
Q: Do I need to select a default for each section?
A: No, you are not required to select a default for every section. If you prefer to manually map specific sections, you can simply leave those sections blank.
Q: What happens if I do not set up default mappings?
A: Default mappings are designed to automate mapping of new payroll categories that are added to your integration. If you choose not to enable default mappings, you will need to manually select the appropriate account for each new payroll category.
Please note that the sync will be paused until all categories are mapped to an account in FreshBooks, which may disrupt your integration process.
Q: When are new mapping categories created?
A: New categories may be created in your integration under the following circumstances:
Each of these actions can introduce new payroll categories that will require appropriate mapping to ensure your integration functions smoothly.
Q: If I set up or change default mappings, will that impact what I’ve already mapped on the Detailed tab?
A: No, this will only impact new categories that may be added to your integration going forward. If you would like to adjust your detailed mappings, you can do so manually in the Detailed tab.
Q: Can I change my default mapping selection later?
A: Yes, you can change your default mapping selections at any time. Any changes will only affect future mappings—your existing mappings will remain unchanged.
Q: If I update my mappings, can I re-sync a payroll to update the entry?
A: Yes. In FreshBooks, make sure to delete the original entries synced from Gusto before or after you resync the payroll.
To re-sync a payroll:
Q: How do I break out individual employee payroll items?
A: You can change the journal consolidation method to “by employee.”
To do this:
Q: Why can’t I find the FreshBooks account I’m looking for in the drop-down?
A: The initial list in the drop-down menu shows recommended accounts based on the selected category. To choose a different account, simply type the name of the account into the search box.
If you still cannot find the account, it may need to be created in FreshBooks first. Once you’ve created the account, click Refresh Chart of Accounts in Gusto and try searching for it again in the search box.
Q: What if I will not be using one of the payroll items listed?
A: The item will still need to be mapped to an account. If the payroll item is not applicable, nothing will sync related to the account that is selected within your entry. Only payroll items that apply to a processed payroll will populate within the synced entry.
Q: Can unique reimbursements be broken out through separate mappings?
A: No, all reimbursements will be pushed over as a lump sum (e.g. Cell Phone Reimbursement + Gym Reimbursement + Office Supplies Reimbursement, etc.).
Q: Can I use more than one tracking category or journal consolidation method? For example, can I consolidate my bills or journal entries by employee and by job?
A: No, not at this time. You must choose to consolidate by one method (by employee, department, job, or project). Next, you may select one class for each employee, department, job, or project.
Q: Can I change the way I consolidate my mappings?
A: Yes, you can change your consolidation preferences at any time. Simply go to the Manage tab located under Settings. However, keep in mind that any changes will result in the deletion of previous consolidated account mapping overrides.
Q: Do I need to set up overrides for consolidated mappings?
A: Setting up overrides for consolidated mappings is optional. It's not required, but it does provide you with the opportunity to customize the mapping layout for each unique grouping you've established.
Q: Why didn’t my sync work?
A: A sync may stop working if your FreshBooks integration has been disconnected or if there are missing account mappings.
Reconnecting FreshBooks: If your integration has disconnected, follow the steps in the "Connect your FreshBooks account to Gusto" section to reconnect.
Checking for missing mappings: To make sure all payroll categories are mapped, go to the Detailed tab and review each section. If an account is unmapped, a red pill indicates a missing mapping in that section. To resolve this, refer to the "Map your chart of accounts" section of this article.
Q: Why did Gusto disconnect from FreshBooks?
A: Occasionally, an authorization issue might disconnect the integration. To resolve this, simply reconnect the integration:
After re-establishing the connection, all your previous mappings should be preserved.
Q: If I update my mappings, can I re-sync a payroll to update the journal entry?
A: Yes. Each sync creates a new expense in FreshBooks. Make sure to delete the original entries synced from Gusto before or after you resync the payroll.
To re-sync a payroll:
Q: Do you break out individual taxes?
A: Gusto handles all of your tax payments automatically. Because of this, you do not need to track tax liabilities. When we sync entries, we record employer taxes as expenses.
You can select for employer taxes to be broken by each individual tax or lump them together. You’ll find this option on the Manage tab under Settings.
At this time, we only support one account mapping which will be used across all employer taxes.
Employee taxes are not broken out individually for mapping or in journal entries, as these values are included in Gross Wages.
Q: How do contractor payments sync over?
A: You have two options for syncing contractor payments. Click here to learn more.
Q: Is there a way to retroactively sync all payrolls once I enable auto-sync?
A: Auto-sync will only work for the payrolls moving forward from the time it is set up. Any payrolls run before auto-sync was enabled will need to be manually synced.
Q: What does the timestamp indicate?
A: The exact time Gusto successfully synced a payroll into the accounting software.
Q: Can I re-sync an entry that has already been reconciled?
A: Yes. Each sync creates a new expense in FreshBooks. Delete the expense in FreshBooks. Then, re-sync the payroll.
Q: Can I sync international employee payrolls to FreshBooks?
A: Not at this time.
Q: Can I sync Gusto or NEXT insurance invoices to FreshBooks?
A: Not at this time.
Check out FreshBooks’s help center.