This article covers the Accounts 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 an Account?
Accounts are what businesses use to track transactions, like money coming in (income or revenue), money going out (expenses) and value of things (assets). There are five basic account types: asset, liability, income, expense and equity. Accounts are part of the chart of accounts and often called “ledgers”.
Amalgam allows you to create, view, or update any data connected with an Account in Quickbooks, including all of the required fields you see in the “Create Account” 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 Accounts
When you want to download a group of accounts to your worksheet, you can use the filters section (on the left side of the Resource template) to select only the purchase orders you wish to download.
- Parent: select only Accounts that fall under a specific Parent account
Account Data Structure
Every row represents a specific account. Therefore, any changes to a row will affect that respective account. The only thing to note when creating a sub-account is it must have a Parent Account’s ID associated with it, which you can find in the hidden columns.
In the Accounts Resource, only the most commonly used fields are visible by default. You will see several hidden columns, indicated by a “+” button at the top of the sheet. By unhiding those columns, you can access several less-common fields.
There will be several fields in each Account that refer to other Quickbooks data. For example, each sub-account is assigned to a parent Account, and that parent Account 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.