13.2. Business Setup

To set up GnuCash to handle accounts receivable or accounts payable for a company, these preliminary steps must be done.

13.2.1. Account Setup

There are many different ways to set up a business account hierarchy. You can start with the Business Accounts setup which is available from the New Account Hierarchy assistant, or you could build one manually. To access the prebuilt Business Accounts, start GnuCash and click on FileNew File and proceed until you see the list of available accounts, select Business Accounts.

The prebuilt Business Account hierarchy will not meet your needs exactly. You will need make adjustments to the hierarchy so that it will meet your particular needs. It should be close enough, however, that it is recommended you begin with it.

To use GnuCash’s integrated accounts receivable system, you must first set up a special account (usually a sub-account under Assets) to hold transactions for receivables. This account must be defined with account type A/Receivable. GnuCash will use this account to place transactions related to the integrated accounts receivable system.

To use GnuCash’s integrated accounts payable system, you must first set up an account (usually a sub-account under Liabilities) to hold transactions for payables. This account must be defined with account type A/Payable. GnuCash will use this account to place transactions related to the integrated accounts payable system.

Basic A/R and A/P Account Hierarchy:

-Assets
   -Accounts Receivable
   -Checking
-Expenses
  ...(as required)
-Income
   -Sales
-Liabilities
  -Accounts Payable
  -Tax
      -Tax on Purchases
      -Tax on Sales

You need to add additional accounts to this hierarchy for it to be useful.

Note

You do not need to create an individual A/R account for each customer. GnuCash keeps track of customers internally and provides per-customer reports based on the internal tracking. The same applies to A/P and vendors.

Note

If you deal with customers in more than one currency you will need a separate Accounts Receivable account for each currency.

If you deal with vendors in more than one currency you will need a separate Accounts Payable account for each currency.

Note

Transactions involving an Accounts Receivable or Accounts Payable account should not be added, changed or deleted in any way other than by using Post/Unpost Bill/Invoice/Voucher or Process Payment!

13.2.2. Setting up Sales Tax Tables

Sales Tax Tables can used to determine the tax for customer invoices (or vendor bills).

A tax table entry can be assigned to an invoice line or bill line.

Set up distinct tax tables for customers and vendors.

The default invoice tax table entry can be assigned to each customer and the default bill tax table entry can be assigned to each vendor.

The default tax table entry for new customers or new vendors can be specified in the Book Options window which can be accessed by FilePropertiesBusiness tab.

Sales Tax Tables are maintained using the Sales Tax Table editor which is accessed via menu BusinessSales Tax Table .

Figure 13.1. Sales Tax Tables Editor

Sales Tax Tables Editor

Figure 13.2. New Sales Tax Table Entry

New Sales Tax Table Entry

  • Name This is the tax table name.

  • Type Either Percent % or Value $.

  • Value This is the percentage or value depending on Type.

  • Account This is the account to which tax will be posted. For tax collected from customers, this should probably be a Liability account as it must be payed to the government. For tax paid to vendors, if tax laws allow tax paid to vendors to offset tax collected from customers, this should probably also be a Liability account (even though it will usually have a debit balance) so that the net tax owed to the government can be easily observed.

    If you set up Tax on Purchases and Tax on Sales as subaccounts of Liabilities:Tax then the net tax will be rolled up and can be seen in the GnuCash Accounts tab.

    If unsure about tax law requirements, get professional advice.

The following charts illustrate sample tax tables and may be used as starting points to determine the setup appropriate for a particular jurisdiction.

Table 13.1. Sample Tax Table Entries for EU country (e.g. 21% / 6% / 0% Belgium, 20% / 5% / 0% UK etc.) (2017)

Tax Table Tax Table Entries [Asset/Liability] Percentage or Amount
Standard VAT Sales VAT:Sales:Standard [L] 21%
Reduced VAT Sales VAT:Sales:Reduced [L] 6%
Zero-Rated VAT Sales VAT:Sales:Zero [L] 0%
EC Sales VAT:Sales:EC [L] 21%
VAT:Sales:Reverse EC [L] -21%
Standard VAT Purchases VAT:Purchases:Standard [A] 21%
Reduced VAT Purchases VAT:Purchases:Reduced [A] 6%
Zero-Rated VAT Purchases VAT:Purchases:Zero [A] 0%

Table 13.2. Sample Tax Table Entries for Australia (2017)

Tax Table Tax Table Entries [Asset/Liability] Percentage or Amount
Standard GST Sales GST:Sales:Standard [L] 10%
GST-free Sales GST:Sales:Zero [L] 0%
Standard GST Purchases GST:Purchases:Standard [A] 10%
GST-free Purchases GST:Purchases:Zero [A] 0%

Table 13.3. Sample Tax Table Entries for Cook County, Illinois (2017)

Tax Table Tax Table Entries [Asset/Liability] Percentage or Amount
Chicago Sales Taxes Taxes:Sales:State [L] 6.25%
Taxes:Sales:City [L] 1.25%
Taxes:Sales:County [L] 1.75%
Taxes:Sales:Region [L] 1%

13.2.3. Enter Company Information

After you have built the account structure and defined your tax tables, designate your company in the GnuCash file. To do this, select the Business tab in the Book Options window, which can be accessed from FileProperties .

Figure 13.3. Entering Company Information

Entering Company Information

Here you can:

  • Enter the name of your company along with contact information such as your phone number, fax number, e-mail address and website URL.

  • Enter your company’s tax payer id number in the Company ID field.

  • Select default tax tables applicable to your most common customers and vendors.

13.2.4. Setting Business Preferences

Set options on the Business tab of the GnuCash preferences, which is accessed via EditPreferences ( GnuCashPreferences on macOS). See GnuCash Manual chapter 10.3.3 Business Book Options Tab.

13.2.5. Setting Billing Terms

Billing Terms can be used to determine the payment due date and be a guide for determining discount for early payment of invoices (or vendor bills).

Note

As of GnuCash 2.6.7, Billing Terms are only partially supported. Date due is calculated using the Billing Terms but discount amount is not.

Discount for early invoice payment is not implemented. There are 2 ways this may be done, although neither is recommended, and professional advice should be used to confirm that regulations are being complied with:

  • After creating and posting a payment which pays the invoice in full, manually edit the payment transaction (usually strongly discouraged) and split the payment to reduce it by the amount of the discount and create a compensating split in an income (discount) account.

  • Alternatively, after creating and posting a payment for the discounted amount, create a credit note for the discount using a specific negative sales income (discount) account for the transfer account.

You can specify the billing terms on each invoice/bill. Invoice billing terms will default from the customer billing terms. Bill billing terms will default from the vendor billing terms.

Billing Terms are maintained using the Billing Terms Editor which is accessed via menu BusinessBilling Terms Editor .

Figure 13.4. Billing Terms Editor

Billing Terms Editor

Figure 13.5. New Billing Term

New Billing Term

  • Name The internal name of the billing term. For some examples of billing term names and descriptions see https://wiki.gnucash.org/wiki/Payment_Terms.

  • Description The description of the billing term, printed on invoices

  • There are 2 types of billing terms, with different information to be entered

    • Type Days

      • Due Days The invoice or bill is due to be paid within this number of days after the post date

      • Discount Days The number of days after the post date during which a discount will be applied for early payment

      • Discount % The percentage discount applied for early payment

    • Type Proximo

      • Due Day The day of the month bills are due

      • Discount Day The last day of the month for the early payment discount

      • Discount % The discount percentage applied if paid early

      • Cutoff Day The cutoff day for applying bills to the next month. After the cutoff, bills are applied to the following month. Negative values count backwards from the end of the month.