Skip to content

Resource: QuickBooks Bills

This article covers the Bills Resource in detail. If you haven’t yet learned about Resources in general and how to get the most out of them, we suggest you check out our Resources support article first.

What is a Bill?

Bills in Quickbooks is an Accounts Payable transaction that represents a request-for-payment from a third party for goods and services rendered, received, or both.

Amalgam allows you to create, update, or delete any data connected with a Bill in Quickbooks, including all of the required fields you see in the “Create Bill” screen in the Quickbooks web interface. Amalgam also allows you to view and modify additional fields that aren’t typically visible in the Quickbooks website.

Filters for Downloading Bills

When you want to download a group of bills to your worksheet, you can use the filters section (on the left side of the Resource template) to select only the bills you wish to download. These filters are cumulative (so if you make multiple selections, you will get results that fit all filters).

  • Vendor: select only Bills from a specific vendor to download
  • Start Date / End Date: find Bills dated on or after, or on or before, the specified date
  • Due After / Due Before: find Bills due before or after the specified date
  • AP Account: find Bills from which AP account the bill was credited
  • Balance Greater Than / Less Than: find Bills where the balance is greater than or less than specified value
  • Custom Field #1, #2, #3: choose which of your QuickBooks custom fields to show in the sheet (see Custom Fields below)

Custom Fields

If you use custom fields on Bills in QuickBooks Online, such as a project code or a department tag, you can view and edit them in Amalgam. Each of the three Custom Field filters lists the custom fields set up in your QuickBooks company. Pick a field in Custom Field #1 and its value on each Bill appears in the first custom field column, and so on for #2 and #3. Leave a filter empty and that column stays blank.

To change a value, edit it on the Bill’s first row and upload. A few limits:

  • Custom field values belong to the whole Bill, so they go on the first row only. A value on a line row stops the upload.
  • You can change a field the Bill already has a value for in QuickBooks. If the Bill has never had a value for that field, set it once in QuickBooks Online, then download the Bill again.
  • New Bills created from the sheet can’t set custom fields yet.

Bill Data Structure

Bills consist of one bill with multiple Bill Lines. Some Bill data applies to the whole Bill, other data applies only to a specific line. For example, each line may have its own billing account and dollar amount, but all lines will share the same due date and vendor name.

In the Bills Resource, only the most commonly used fields are visible by default. You will see hidden columns, indicated by a ”+” button at the top of the sheet. By unhiding those columns, you can access several less-common fields.

Note that some of these fields may have formulas in them. These are often used to fetch IDs for Quickbooks data, stuff that is required by the Quickbooks app, but which isn’t important to a user. We caution against changing this data unless you know what you’re doing!

Reference Fields

There will be several fields in each Bill that refer to other Quickbooks data. For example, each Bill is assigned to a Vendor, and that Vendor must exist in Quickbooks. Amalgam makes these references easy for you by providing you with a dropdown list containing all of your options.

If you ever wish to refresh these lists, there is a refresh button on your sidebar that will sync your options with the latest data in Quickbooks. This can be used in conjunction with other Amalgam templates to make edits in Quickbooks without ever leaving Excel or Google Sheets.