How-To Guide

Posting Expenses: Step By Step

  

In this article we’ll be showing you how to post your reimbursable expenses from BigTime into your QuickBooks file so it may generate a check or bill against the appropriate Vendor or Employee.

Integration Management Delegates The Flow Of Expenses

After your initial BigTime integration with Quickbooks, you will setup the default accounts that checks and bills should be associated with. The System Administrator can navigate to MY COMPANY... INTEGRATIONS. Click on the QuickBooks product you  are currently using (QBO or QuickBooks Desktop). Click the Manage icon  inside the product integration page. The system will automatically load specific integration settings that delegate which accounts the expenses will be  associated with.

A frame will pop up, allowing you to setup General, Time/Expense, or Invoicing settings. Click on Time/Expense and you’ll see the picklist menus. This is where you will set the specific Checking and Accounts Payable accounts needed  in order to post expenses. This setting will be the default account that BigTime will always post to.

 

Tip

In this area you can also set up the requirement that timesheets or expenses must be approved before a request to post can be to QuickBooks.


 

Unique Integration Of The BigTime Staffer

One important property of BigTime that can have a  one-to-many relationship with Quickbooks is the source of the expenses. And that is the BigTime Staffer.

A BigTime staffer can be integrated with multiple records: an Employee, a Vendor, or both. If a BigTime staffer is integrated with an Employee record only, all his/her expenses will go into QuickBooks as a check. If the user is integrated solely with a vendor record, then the user’s expenses will go into QuickBooks as a bill payable to the Vendor. If however, the BigTime staffer is linked with both an employee and a vendor record, the timesheets will go against the employee record, and the expenses will go into QuickBooks as a bill payable to that particular vendor record.

Expense Codes

Expense codes are required field be integrated in order to post expenses. The expense codes within BigTime describe the type of expense that the user is submitting. For example,  it can be Travel:Mileage or Office Expenses. These codes are pre-populated but are not automatically integrated with QuickBooks. These default values can be deleted, renamed, and integrated with Other Charge items of Quickbooks or Expense Accounts.

To integrate the expense codes, the system Administrator can navigate to MY COMPANY...FIELD VALUES...EXPENSE CODES.

Clicking on the name of the Expense code will show you GENERAL INFORMATION, where you can select the QuickBooks link under the header “SERVICE ITEM.” This picklist will show your active QuickBooks item list, as well as Expense accounts that are available to integrate with.

Credit Cards

Credit cards are another type of expense that can be posted to QuickBooks. The ability to create credit card expense entries is  not available to the end user until the credit cards are setup. To set up credit cards, the system Administrator can go to MY COMPANY...FIELD VALUES and click on the FIELD VALUES header. To create credit cards within the Credit Cards section, click Add new value. The Administrator only needs to specify a name, a QuickBooks link, and also has the option to allow all users to log to the credit card or just specific users.

 

 

  1. Click on the QuickBooks tab on the navigation bar at the top of the page. Select POST EXPENSES.


  2. Select the expenses you wish to post to QuickBooks. Click on the checkbox next to the expense to select it.

  3. Click POST SELECTED EXPENSES to submit them to QuickBooks. This button is located at the top left of the screen.

 Once a transaction of expenses is requested to be posted to Quickbooks, there are three available states the expense report can go through:

Pending

A pending post transaction occurs directly after the Financial Administrator selects Post Expenses. The icon next to an expense report spins with animation until it lands on a cloud icon that is light gray.

 

Success

If the request made to QuickBooks has succeeded, the icon will change from a gray cloud to a green check mark.

Failure

If your request to QuickBooks has returned as failed , the gray cloud will change to a red cloud icon.

If you hover over the red cloud, you will see an error message that explains the specific things that need to be done in order to get the expense posted over correctly. Once the corrections are made, the Financial Administrator can then re-post the transaction.

Correcting A Posted Expense Report

Once a post has been successful, the hand-off is complete. If any corrections need to be made on a posted expense report, the expense will have to be deleted from QuickBooks and then posted again from BigTime. This will generate a new expense.

To do this, the Financial Administrator can go to QUICKBOOKS...POST EXPENSES and check  the  box next to the name of the expense report  to be reposted.  Checking the box  activates the option to mark an expense report as unposted. Click the Mark as unposted button to access  the option to post the  transaction again.

ALERT: If you do not delete the originally posted report from within QuickBooks, this will result in a duplicate check or bill being generated in the file. Always remember to delete the first expense posted.

 

 

Was This Helpful?