Billing Entry

Billing Entry is a Payables transaction for adding or modifying invoices (and credit invoices) for future disbursements of payments to vendors (payees). You cannot view or select previously paid invoices from this area. Instead, use the Inquiry and Billing tools to view paid invoice information. When invoicing purchases of inventory, use the Receipts (F5) function to select the purchases (receipts) for billing. Receipts can be selected for billing individually or if multiple receipts are being billed together (paid on a single invoice), more than one invoice can be selected.

Basics of Invoicing

Invoicing is usually done soon after a company receives a bill from a vendor (payee). The Vendor Invoice # is provided by the vendor/payee (printed/displayed on the bill the vendor sends). Payable invoices (and credits) are also assigned an application document ID once saved (1712-912821, for example). When checks are printed, all of the vendor's invoices (and credits) selected for payment are printed in the voucher area along with their amounts. This is done so the vendor can identify which invoices (bills) are being paid by check. The "description" is also printed on the check voucher and can also be used to reference the invoice if you choose to use a different identifier that does not match the vendor's invoice.

Payables invoices have a payment status assigned to them (open, hold, pay in full, etc.). The status determines whether and how an invoice will be handled when disbursing payments. Invoices are typically either linked with a purchase (accrual) or expense. Inventory Receipt and Direct Ship documents can be directly associated with a Payables invoice. Certain actions, such as Point of Sale refunds, can automatically generate a Payables invoice in some cases. Invoices must be associated with at least one ledger account that indicates the offset(s) to the Accounts Payable account. Your company's AP or Accounts Payable account does not need to be referenced, only the offsetting account entries. Offsets are usually either the Accrual Account (for purchases of inventory) or some type of expense account.

Vendor Invoice #

For new invoices, you must type the invoice number from the bill and press Enter. To review or modify a previous invoice, type in the number or select from the drop down. Only invoices that have not been fully paid can be selected. To view paid invoices, either use the Documents option to view AP Billing Invoice documents (you can select by vendor) or use the Billing Inquiry form.

A document is generated for each A/P invoice saved. Document numbers display to the right of the vendor's invoice when modifying an existing payable, but are not available on new payables until after processing.

Some companies print a bar coded label when they process invoices. The label may be attached to the vendor's bill and contains the document ID for the payable's invoice. Document labels make linking outside documents with Spruce documents much easier. Doing this requires a DYMO LabelWriter 450 (or 400) Turbo printer and appropriately sized labels. These can be purchased directly from DYMO or other sources (sorry, we don't sell DYMO printers or supplies). If a DYMO printer has been configured for your station, the Payables process form will display additional fields ("Print Identifier" and "# Labels"), see below:

Another way to link the vendor's document to your Payable is to scan the document and attach it to the Document (using the Document Folder (F4) tab). The scanned copy becomes an attachment that is permanently linked with the Payables document and can be accessed from the Document Viewer.

Vendor and Pay-to Vendor

The vendor is the company or individual that the supplied goods or services and is usually the party who sent your company the bill; however, the vendor is not always paid directly. Some goods or services may be provided by one particular company but the bill is paid to another entity (a co-op or buying group, for example). The actual payee is known as the Pay To and may be either the same as the "vendor" or different. Both are considered "vendors" and must be set up in the Vendor Database prior to use. It's possible to designate that any particular vendor always use a particular pay-to as a default.

Using the MISC Vendor

For one-time miscellaneous payments, the MISC vendor can be used to pay an individual or company. This special vendor does not track payments or purchases/expenses separately for each payee, so it is not suitable for any payee that might require 1099 reporting (or if you need to view vendor information separately for any other reason).

The MISC vendor is not added or available automatically for use in Payables, it must be added in Vendor Maintenance if it is to be used. The vendor code and pay-to on this vendor must be "MISC" to function properly. A MISC vendor is required for merging Items if receipt history for the product must be merged.

What is the MISCPOS Vendor?

This vendor is similar to the MISC vendor, but is exclusively used for Point of Sale refunds that have been designated to be paid via "back-office check" (payables). When used, refunds designated for payables payment generate an invoice for the MISCPOS vendor that includes the customer's information (as typed or listed on the Point of Sale process form). The invoice number generated will be the document number prefixed with "POS#" (see below).

POS#1803-5341

The MISCPOS vendor is not created automatically, so it must be added in Vendor Maintenance if it will be used. If the MISCPOS vendor is not defined, refunds in Point of Sale that have been designated for payment through payables won't generate any invoice.

When an invoice assigned to the MISCPOS vendor is selected, an "Account" control will appear to the right of the vendor. This was added so that Payables users can auto-complete the address information matching with the customer's account they select. When a MISCPOS invoice is selected, document notes are added that include the original customer's name from the refund.

Installed Sales Vendors

Vendors may be designated as an "Installed Sales" type. This vendor type is used for 3rd parties your company pays for installation services and/or materials. For example, your company might sell hardwood flooring. When a customer purchases flooring from your company and wants it installed, you might have a contractor or company do the installation on your company's behalf. In this case, you pay this 3rd party, not the customer. Invoices for "installed sales" vendors can be linked with an existing Installed Sale contract so that the expense may be recorded for profit analysis.

When billing entry involves an installed sale vendor, a special process form icon appears. Clicking on this icon opens a form where you can select one or more installed sale contracts. The payable's invoice will be linked with each contract you select (will appear on the 3rd Party tab).

Foreign Vendor

Vendors can be designated as a "Foreign Vendor". This vendor type is used when a vendor uses a currency other than what the default local currency is set to (see Vendor Maintenance). The "Bill Amount" will be shown in the local currency while the "Billed" and "Remain" values will be shown in the foreign currency. In the example below, the local currency is set to use the Canadian dollar, but the vendor is a US based company and bills using US funds. The Vendor's currency will also show next to the "Pay To" field.

Receipts (F5)

After vendor selection, the Receipts (F5) function becomes active. Use this function to select inventory purchases for payment/invoicing. Multiple selections can be done, and, if enabled, partial payments can be indicated. Choose Select All (ALT-S) to mark all receipts for invoicing or instead, click in the check box next to the receipt(s) individually. Once selection is complete, choose Accept (ALT-A). A total of all selected receipts is displayed in the selection window for reference (Total Received). A Payables parameter, "No Partial Receipt Billing," can be used to disable the partial billing feature on this form. When disabled, the check box column "Partial" and the three (3) columns, Orig Amount, Prior Billed, and Bill Amt, are replaced by an "Amount" column.

Partial Payments (if permitted)

To specify a partial payment, enter an amount less than the amount remaining (original amount - prior billed) in the "Bill Amt" column. This is the only column that allows for text entry. Reducing the "billed" amount will automatically select the row and set the "partial" check box. You can choose "partial" before changing the amount; however, the "select" check box is not automatically selected in this case.

Once a partial payment on a receipt has been invoiced, the "prior billed," will then reflect the amounts. Billed amounts that exceed the remaining are not allowed. This is intentional and is done to maintain the balance between the accrual and ledger entries created by receipt selection. If you are being billed for a different amount, you can either fix the receipt prior to billing (using cost corrections, for example), or change the invoice amount after receipt selection. Changes to the billed amount will require that additional ledger selections be made.

The name and address information is filled in automatically after vendor selection. The Pay To defaults to the designated "pay-to" for the vendor if one is designated; otherwise, the pay-to and vendor will be the same. Users can modify the pay-to vendor during entry if needed. Address information in the Billing Entry area displays the Pay To's information.

Note: If a billing invoice is linked to a partially received receipt and the bill is re-opened, the receipt is not reopened.

Direct PO (F7)

The Direct PO (F7) function is used for associating an invoice with a Direct Ship to a customer. Only one direct shipment can be associated with any given Payable's invoice. Direct shipments are initially processed through the Point of Sale, Direct Order activity. This type of transaction is used when goods are being shipped directly from a vendor (supplier) to a customer. Due to this, no inventory is involved, so it must be handled a bit differently in a number of ways.

Direct Ship may orders hold a "deposit" until they are invoiced in Payables. If the customer paid the deposit using their account (charge deposit), a debit adjustment was created at that time and the Direct Order is considered "Paid in Full" by a deposit. Debit adjustments for "charge deposits" occur immediately upon processing the Direct Ship order and are not held for Payables billing. The order is considered "paid in full" in this case and the deposit was immediately billed to the customer's account, so the "invoice" of the Direct Ship Order won't ever appear on the customer's account in this case.

One difference between a Direct Ship and a regular purchase of inventory is that goods are never received, so there is no accrual associated with the purchase. Instead of associating the payable with a Receipt, it's done with by choosing a "direct" Purchase Order instead. To handle the lack of any real accrual, the Point of Sale journal can be mapped with a "dummy" accrual account to be used for direct ship type purchases. The invoicing of the Direct Order to the customer happens automatically when the payable is processed (when the invoice is saved, not when it's paid). The Point of Sale ledger entries created by this will offset the accrual account for the Payable (creating a "wash" entry).

Transfers (F8)

The Transfers (F8) function is provided for invoicing adjustments (adders) associated with a "transfer-in" document. Transfers "in" are branch-to-branch transfers of inventory where your (the current) branch is the recipient of the materials transferred. Adjustments are provided as an option for transfers "out" and pending transfers. These might be used when a 3rd party is providing shipping, for example. Transfer adjustments are available for billing processing in Payables from any location once either the transfer-in or pending transfer has been received. Transfers are only included when containing adjustments for the current material vendor (or the Pay-to if one is selected and if no material vendor has been designated).

If multiple transfer adjustments are found for the same vendor, they may be invoiced together. By default, adjustments affect the accrual account both when the transfer is processed and after invoicing the payable. Up to three (3) adjustments may be optionally associated with each transfer document.

Description

You can always specify a Description for a Payable; however, the description also may be automatically set in some cases:

• Receipts

If you have not entered a description previously and are invoicing a receipt using the Receipts (F5) function, the description will be auto-filled with the word "receipt" followed by the document number of the first receipt selected. Multiple receipts may be associated with the same Payables invoice, so only the first one is used.

• Direct Sales (aka. Direct Ship)

If you have not entered a description already and are invoicing a Direct Purchase Order using the Direct PO (F7) function, the description will be auto-filled with the text "Dir PO" followed by the document number of the first receipt selected. Only one Direct PO may be associated with a Payables invoice at a time, so if a Direct PO is selected and then changed to another, the description will not automatically change (unless you clear the description before changing your Direct PO selection).

• Point of Sale Refunds (MISCPOS)

Returns and refunds in Point of Sale may be paid using Payables rather than returning cash (or checks, etc.) from the drawer. This might be used in situations where you want to verify a purchase or wait for a customer's deposited check to clear the bank before issuing a refund, for example. It may or may not be a part of your company's standard procedure for refunds. When a Payables invoice is created from Point of Sale processing (returns/refunds), it is automatically assigned a description of "POS Refund." This may be modified by the payables user.

Batch Date

This date is provided for grouping payables into a batch. For example, you may want to process all the payables being paid on the 10th of the month at the same time, but the invoices will have different due dates, discount dates, and entry dates. If you manually assign them to the same batch, you can both select and pay invoices based upon the "batch date" rather than the other dates (due, discount, and entry).

GL Transfer Eligible

Below the description area, there is a GL Transfer Eligible check box. Usually, processing an A/P invoice creates journal entries so invoices that are either Paid or Partially Paid during the business day update the General Ledger. This occurs during the End of Day process. However, when you choose the GL Transfer Eligible check box, you "force" the invoice transfer to the General Ledger, so it appears as part of the Accounts Payable balance before the payment is processed. When you do this, the application applies the changes to the A/P liability account and either the Expense or A/P accrual account (used as a holding account for inventory purchases) during the End of Day process, and the changes are visible the next day.

Selecting the GL Transfer Eligible check box transfers the invoice to the ledger as part of the End of Day process.
Note: You can use the Transfer A/P utility to update payable records manually immediately.

When you process the Billing Entry transaction, the application generates the General Ledger entries for these records during the End of Day process. This affects these accounts' purchase or payment values and the Accounts Payable liability account balance. If you do not have the GL Transfer Eligible check box selected during the Billing Entry process, the application makes these ledger entries when the invoice is paid instead.

Your company can choose whether the GL Transfer Eligible check box is selected by default.

To set the GL Transfer Eligible check box by default:

1. From the Main Menu, choose Maintenance > Database > Parameters.

2. Click the Payables tab.

3. Check the Default Setting for GL Transfer box.

4. Choose Process (F12) to save this setting. Setting this option requires administrative permissions.

Using the Reverse and Close and Delete Options

The menu marker, if enabled, offers two (2) choices: Delete Invoice and Reverse and Close. These options may be hidden if your user is not a system or Payables administrator type user.

       

There are rules about when it's possible to delete or reverse an invoice in the Billing Entry form. Security settings may block user access to menu markers:

• In both cases, the invoice must have a status of Open.

• When deleting, the invoice must not have been transferred to the ledger.

• For a reversal, the invoice must have been previously transferred to the ledger.

• In both cases, the invoice must not have been partially paid.

Reversing an invoice provides additional function if the invoice has been transferred to the ledger. When a reversal is done, another invoice is generated reversing the original. If the invoice being reversed is a credit, a new debit invoice is created. On the other hand, if the invoice was a normal debit invoice, a credit is created. The invoice number of the new offsetting invoice will match the original except that a suffix of R (reversal) is added. Both the reversal and original invoice maintain separate documents and can be viewed in the Billing Inquiry form. When an invoice is reversed, both the invoice and the associated reversal invoice are marked with a status of "void."

In cases when the original invoice's G/L cycle has been closed, the reversal invoice determines the cycle based on the current date at the time of reversal (not the oldest open cycle necessarily). For example, if a transferred invoice was originally expensed in March of 2017, the current (oldest open) cycle is December 2017, but today's relative cycle is May 2018, the invoice will be placed in May 2018 because March 2017 is closed.

Note: If a billing invoice is linked to a partially received receipt and the bill is re-opened, the receipt is not reopened.

---

Billing Panel

Bill date and bill amount can be modified on an invoice if the invoice has not been transferred and has not been partially paid. Remaining is automatically affected if the bill amount is modified.

Bill Date

This is intended to be the date that the bill was received, and defaults to the current date. "Bill Date" is used for determining the discount and due date when terms are involved. Changes to the bill date are only allowed until the invoice has been transferred to the ledger or the invoice has been fully or partially paid. Once transferred or payments have been made, the date will no longer allow modification.

Bill Amount

This is the total amount being billed by the payee (vendor, service supplier, etc.). This amount must match the net total for any offsetting ledger entries before saving the invoice (using the Process (F12) function). Changes to the amount are only allowed until the invoice has been transferred to the ledger or the invoice has been fully or partially paid. Once transferred or payments have been made, the amount will no longer allow modification.

VAT*/GST (UK/AU)

In the United Kingdom (UK), this displays or is used to modify the "value added tax" amount for a purchase or expense or GST in Australia. The VAT/GST location selected will be the first tax location located with an "invoice name" of VAT. Additionally, the VAT Maintenance area for defining the VAT tax location has an option for Payables mapping which isn't currently used. If the purchase involves a receipt of inventory, the VAT is set based on the sub-total of the purchase as well as any adjustments.
Note: The Australian tax code uses the GST label for taxes, which is not to be confused with the Canadian GST. The Australian GST is calculated similarly to the United Kingdom VAT, so typically we group them together in the application. For more about VAT/GST use in the Billing Entry form, see Seeing VAT/GST Discounts in the Billing Entry Invoice.

GST/PST or HST* (Canada)

In Canada, you may see either one (1) or two (2) text areas for tax on the purchase or expense. In provinces or territories where both GST (Goods & Services Tax) and PST (Provincial Sales Tax) apply, two (2) text areas for each will be provided; otherwise, if your company operates in a "harmonized" (HST) province or territory, a single text area is provided for the combined tax. When GST is shown, the GST tax location set in Parameters is used (Main Menu, Maintenance, Database, Parameters and choose the Point of Sale, Settings tabs). The PST or HST location is determined by the tax location assigned to the current branch initially but is changed to the receiving branch when invoicing a receipt for another location.

*Not shown in the United States.

EDI Created

The EDI Created check box indicates that the payable was generated automatically using data from a 3rd party. EDI means "electronic data interchange" and describes any process or method where data is exchanged between parties using electronic means. When EDI processing generates invoices, the status of those invoices may be set to "hold" in certain circumstances. Usually, the reasons for this are linked to whether a supporting purchase can be associated with the bill as well as whether or not there is a difference in the billed amount and how much of a difference.

If the EDI invoice was placed on hold, a reason will appear next to the status drop down. There are three (3) reasons: none, No PO, and Amounts Differ. "None" means that the invoice was placed on Hold independent of EDI processing (manually changed by a user). The "No PO" reason means that a matching purchase order document could not be located so no comparison was possible (purchase orders are required for some EDI processing). If "amounts differ," it means that a purchase order was located, but the amounts differ between what was billed and what was received. If the "threshold" parameter is set to an amount above zero, only invoices that differ more than a set dollar amount are placed on hold. A second parameter, based on a percentage difference, has been added. Either threshold (dollar based or percent based) can trigger the "hold" status. Both are optional.

Separate Check

The Separate Check option indicates that a particular payable (invoice) should be issued a check separately rather than be combined with other selected invoices for the vendor on a single check. This option shouldn't be used with credit invoices. In the case of a credit, checking this option would stop a credit from being applied toward a payment involving other invoices, and since you can't have a "credit" check, the credit would not wind up being included in a disbursement even if selected.

Pre-paid Purchases

Use the "Pre-Receive PO#" drop down to select a purchase order that is being billed prior to receipt. This might be done in cases where you are required to pay for goods in advance of shipment. As long as their is no default ledger account associated with the vendor, the accrual account will be used when selecting a Purchase Order to pre-receive.

If you partially pre-bill a purchase (pay part of the total), the receipt of the PO won't be left open for the final payment of the balance. In this case, you must manually invoice the payable. The debit offset will be the accrual account for the remainder of the amount due.

Discounts and Terms

Vendors may offer discounts for early or on-time payment. In some cases, the discount terms always stay the same, and in others, they change based on a number of factors. For vendors (payees) with consistent discount terms, it's possible to designate default terms using a "terms code." A database exists for vendor terms codes, and allows terms to be defined based on a number of criteria (for example, terms codes can set discount/due dates based on the number of days from the invoice's bill date or instead, specific dates such as the 10th day of the month, etc.). Terms codes can be assigned to vendors (usually done when the vendor consistently applies the same conditions to billing), or they can be added during invoicing (Billing Entry). In place of terms codes, it's possible to manually set a discount and due date during invoicing along with a percentage or dollar amount discount.

Discounts and terms, when in place on an invoice, are enforced based on the vendor's "discount rules." Vendors can be set up to "always take" discounts or to "pay by discount date." If the "pay by discount date" option is used, the date the bill is paid (disbursed) determines whether or not discount will be taken. If the "always take" option is used, payments will be reduced by the discount regardless of the payment date.

When specifying a dollar amount as a discount ($ Discount), it's important to understand that any previous percentage amount displayed will not be converted to the dollar equivalent and will be treated as the dollar amount unless modified. The dollar discount option assumes that the user is manually entering a dollar amount, so no calculation is done. Note: To learn more about VAT/GST Discounts, see Seeing VAT/GST Discounts in the Billing Entry Invoice.

Save & Continue

This feature allows your company to enter multiple invoices without being prompted to print a document each time you save. If the "save and continue" check box is selected (checked), the Process (F12) function will save the invoice (or credit) and not display the "process" dialog.

Rebate Credits

When the Rebate Tracking feature is enabled and a credit invoice (negative amount) is being entered, a Maintenance Form icon is provided next to the label "Reconcile Rebates."

This form provides a selection list of the vendor's rebate and item rebate code combinations. Designate the period (month or quarter) and amount for each applicable combination the credit rebate was received for. Processing will result in the credit invoice being reflected in the Rebate Tracking data and inquiry for the selected vendor. A total of the current amounts entered is provided for comparison to verify against the credit amount.

Typically, rebates would be distributed in either of two (2) forms: physical check or a credit toward future purchases. Credits toward future purchases would be entered using this form (Billing Entry); however, actual check payments can be entered using the Payments transaction in Point of Sale (a "Rebate Check" option is provided for this). In both cases, a rebate code and month (or quarter) period can be designated. The Rebate Inquiry form is used to compare the expected rebates to received rebates.

Invoicing and General Ledger

Payables processing can generate journal entries for General Ledger as part of the scheduled processing that runs between business days. There are two (2) distinct parts to recording a payable in the ledger. One part records the expense or purchase. The second records the payment. These may be done at the same time or separately based upon your company's preference.

Payables may be optionally transferred to the ledger before payment to record the expense or purchase separately. This is indicated by checking the "GL Transfer Eligible" check box when adding or modifying a payable --or-- by using the "Transfer A/P" utility. Otherwise, daily processing after disbursing the payable records both (1) the expense or purchase billing in General Ledger and (2) the payment of the invoice. Payment reduces the balance of your company's open Payables and bank account (as mapped in General Ledger for the selected check register).

Purchases of inventory are handled a bit differently from expenses. Purchases (receiving inventory) increase both your company's inventory on the date receipts are processed as well as the A/P accrual account. The "Receiving" journal handles these ledger entries. Inventory is typically recorded as an "asset" in the ledger. The "accrual" account is a special liability account that is used as a temporary holding account until purchases are recorded as Payables and subsequently transferred to the ledger.

You'll notice that the ledger's Accounts Payable (AP) account is not listed. It is not necessary to specify your company's Accounts Payable liability account. All payables are assumed to use your company's Accounts Payable account as the offset to the accounts you specify. If you enter a credit amount for a ledger account, the AP entry will automatically be a debit for the same amount. If you enter a debit, the AP offset will be a credit. Any payables offset amount is calculated with daily processing, not for each invoice or credit. Ledger amounts must equal the invoice's billed amount in order to save the payable.

Manually Choosing an Account

When manually specifying ledger account offsets on a payable, most of the time the account is going to be an expense (or other expense) type. Account types (assets, liabilities, and so on) are assigned to numeric ranges, so the easiest way to select the account is to type the beginning digit(s) of the account number to produce a listing of matching accounts.

Another method, is to use the alternate mouse menu to specify the account types you want included in any selection lists. For example, if you are invoicing and expense such as a utility payment, you might want to select "expenses" and "other expenses" to be included in the selection of accounts. A default ledger account may be assigned to a vendor to simplify entry when invoicing a non-purchase type expense.

Use the check boxes to designate the account types for inclusion in the selection list (in the drop down). If no filtering is done, the entire chart of accounts (posting accounts only) will be listed in numerical order when using the drop down for selection. The "description" option on the alternate menu lists the selected account types (or all accounts if no filtering has been done) in alphabetical order based on the text description of the posting account.

Owner's equity (aka. retained earnings) and net income type accounts are not valid for selection for Payables. Should your intention be to create a payment for an owner's draw or dividend, you must first use a manual journal to transfer the desired amount from the owner's equity account to another liability account. This other liability account would be the offset account selection in the Billing Entry data grid.

 

Seeing the VAT/GST Tax Discounts in a Payables Invoice

After you set the Adjust Tax on Discounts parameter, and verify that the Vendor provides a discount, the application can calculate the VAT/GST discount in the Billing Invoice Entry form. This works the same way whether you process the payable before you receive the materials or after you receive them. It works whether you choose to pay the entire amount or submit partial payments.

In this case, the company has purchased $1890.00 of materials, with a GST Tax of $189.00 for a total of AU $2079.00. Let’s see how that displays in the Billing Entry form. The vendor’s discount is 1% on net 30 terms.

To review the VAT/GST Discount on a Payable Invoice:

1. From the Main Menu, choose Payables > Billing Entry to display the Billing Entry form.

2. In the Vendor Invoice list, choose the invoice with the discount to pay.

3. In the Vendor list, choose the vendor. The application fills in the appropriate fields.

4. Depending upon when you are processing this billing, do one of the following:

• If you are paying the bill ahead of receiving the inventory, in the Bill Amount field, enter the total amount (in this case, 2079.00) and in the VAT field, enter the tax amount ($189.00) and press Enter. The application calculates the item discount and the VAT discount based on the entry in the Terms field using the information you entered.

• If you are importing the information from receipts, choose Receipts (F5) and select the receipt you are paying for. The application updates the Bill Amount, the VAT Amount, and the discount amount fields based on the discount quantity in the Terms field.

Billing Entry Form with GST Payable Discounts Applied

This section of the form displays the discount information. The VAT/GST Disc field contains the application’s calculation of the tax discount. The total discount for the transaction would be (18.90 (for materials) +1.89 (for the tax) = $20.79 discount for the transaction. The application calculates the discount, in part based on the status (Open, PayinFull, Paid, etc.)

5. To ensure that the amounts that display in the transaction are transferred to the appropriate GL account, select the GL Transfer Eligible check box.

6. If you decide to make a partial payment, the application manages the discount based on your pro-rate entry in the Vendor Maintenance record:

• If you selected N in the Pro-Rate Discount field, the application applies the entire discount in the last payment;

• If you selected Y in the Pro-Rate Discount field, the application applies a pro-rated discount amount for each payment.

7. To change the GST Discount, you can type over the amount in the GST Discount field. If you modify the VAT/GST entry manually, the application displays a warning message:

Billing Entry Form Warning Message

8. Select Accept Warning if you are confident that your change is appropriate.

9. When you process the payment, the application keeps track of the discount information you applied.
After the check run, the application applies the calculated discount to the transaction, so the payment amount displays correctly on the check.

Check Run Results

When you look at the AP Billing Invoice, it reflects the discounts for the item and for the taxes:

Billing Invoice with Item and Tax Discounts Highlighted

When you are paying a foreign vendor with a VAT/GST discount, the discount is calculated in the local currency and then applied to the foreign account.

Billing Entry Form with Foreign Vendor GST Discount Highlighted

The Billing Tax Invoice reflects the amounts in both local values and foreign amounts:

Billing Tax Invoice with Foreign Values Highlighted

Reviewing VAT/GST Tax Discount Applied to Partial Payments

In partial payments, you need to check the Pro-Rate Discount field to determine when the discount is applied. To review: In the Pro-Rate Discount field, you indicate whether the discount is prorated.

• When you enter N in this field, the application applies the discount only on the last payment when you make partial payments. In our example, this is the option we show.

• When you enter Y in this field, the application applies the discount on a pro-rated basis based on the amount of the partial payment.

This affects when the discount appears in the Billing Entry form and in the subsequent GL entries.

In this example, we have purchased inventory, received it, and will work with the received records.

To see the partial payments effect on the payable billing (Pro-Rate Discount = N):

1. From the Main Menu, choose Payables > Billing Entry to display the Billing Entry form.

2. Choose Receipts (F5) and pull in the receipt you want to partially pay. The form updates with your changes.

3. In the Status field, choose PartialPay and in the Payment field, enter the amount of the partial payment. Press Enter. The Recalculate prompt displays.

Billing Entry Form with Partial Payment Entered and Recalculate Prompt Showing

Note: If you change the terms entry, a pop-up message displays asking you if you want to re-calculate the term dates and the discount. Select Yes to recalculate the term dates and discount amount. In this case, nothing updates because the discount will be applied when you make the final payment.

4. Choose Process (F12) to process the payment.

5. Run the disbursement process and create the first check. When you look at the first check, there is no discount amount reflected:

Check 1 with No Discount Recorded

6. When we return to the payable, you can see that the first payment amount has been deducted from the total and the Discount fields are disabled.

Billing Entry Form with Second Partial Pay Amount Entered and Discount Fields Disabled

7. Choose Process (F12) to process the payment.

8. Run the disbursement process and create the second check.

Check 2 with No Discount Recorded

9. When we return to the payable, you can see that the second payment amount has been deducted from the total.

10. Choose PayInFull from the Status list. The application moves the cursor to the Pre-Recv/Direct PO# field, so you can select the PO from the list.

Billing Entry Form with PayInFull Selected

11. Choose Process (F12) to process the payment.

12. Run the disbursement process and create the last check.

Check 3 with Discount Recorded

Seeing the VAT/GST Tax Discount Applied to the General Ledger Account

It is also important to see that the VAT/GST discount is applied to the appropriate AP Tax Discount GL account, so you are reporting the appropriate amount of tax to the tax authorities. Setting this up properly ensures that the discount is also recorded in the End of Day (EOD) report so the books balance.

When you process a payment that has a VAT/GST tax discount associated with it, the tax discount amount displays in the VAT/GST Disc field of the Billing Entry form. It is important that you select the GL Transfer Eligible check box to ensure that the application transfers the correct tax amount minus the discount. This is why it is important that you map the tax discount to a GL account before you set the parameter. If you do not add this mapping, the application will separate the tax amount into a separate account, but it will not display the Discounted tax amount on the GL account.

Billing Entry Form with GL Transfer Eligible Field Highlighted

If you choose to transfer the payment amount to the General Ledger account manually:

1. In the Main Menu, choose Payables > Utilities > Transfer A/P to display the Transfer Accounts Payable form.

2. Choose View (F8) to display the eligible transactions.

3. Choose the Select check box at the end of the row of the transaction you want to process.

4. Select the Transfer Now check box.

Transfer Accounts Payable with Transaction Highlighted

5. Choose Process (F12) to complete the transaction.

6. Then go to General Ledger > Inquiry > Journal to display the Journal Inquiry form.

7. In the Journal ID, choose the journal you just completed the transfer for.

8. Then, choose the Accrued Sales Tax entry to see the detail.

Journal Inquiry Form with Sales Tax Detail

9. Run the Disbursement to pay the bill:

1. Choose Payables > Disbursements to display the Disbursements form.

2. Select the appropriate checking account.

3. Choose Process (F12).

10. Run the End of Day GL Report.

11. From the Main Menu, choose General Ledger > Inquiry > Journal to display the new Journal Inquiry form.

Journal Inquiry Form after EOD Report Run

Looking up the Tax Discount in Billing Inquiry

After the disbursement run, you can also review the tax discount on a payable in the Billing Inquiry system.

To review the tax discount in the Billing Inquiry system:

1. From the Main Menu, choose Payables > Inquiry > Billing to display the Billing Inquiry form.

2. From the Vendor Invoice list, choose the invoice we have been working with to display the tax discount information.

Billing Inquiry Form with Discount Fields Highlighted

Setting the Adjust Tax on Discount Payables Parameter

If you decide you want to adjust your VAT/GST tax on an account when there is a discount for on-time payments, begin by setting the Adjust Tax on Discounts option in the Payables tab in the Parameter Settings.

To set the Adjust Tax on Discounts parameter:

1. From the Main Menu, choose Point of Sale > Database > VAT or GST to display the VAT/GST Maintenance form and make sure you have set up the GL mapping for your Payables transactions.
This includes creating a mapping for the new tax discount adjustment.

2. From the Main Menu, choose Maintenance > Database > Parameters to display the Parameter Settings form.

3. Select the Payables tab to display the Payables parameter options:

Parameters > Payables > Adjust Tax on Discounts

Note: The Adjust Tax on Discounts field does not display for non-VAT/GST tax regions. This field will not display for UK applications until the HMRC is updated to handle this feature.

4. Select the Adjust Tax on Discounts check box.

5. Choose Process (F12) to save the change.