Accounts Payable

Overview

A primary function of the system is to track the amounts owed by the business to suppliers in both local and foreign currency. The system shows, invoice-by-invoice, the balance on the account and does not lose the detail of what makes the account up in a balance brought forward - it is an "open item" system. When payments made to suppliers are entered and allocated to invoices, the differences on exchange are calculated and posted to the general ledger - that is only if integration to the general ledger is enabled from the company preferences page under the setup tab.

Note that in some countries the word "Vendor" is used instead of "Supplier" - please make allowances for this.

Features

Entering Supplier (Vendors)

From the menu Payables tab, under Maintenance, click on "Add A New Supplier". The new details entered are only committed to the database as a new supplier once the user clicks on the button to "Insert New Supplier". If the user moves to another screen without clicking this button any entries are lost.

Supplier Code

This field is used as a unique identifier for the supplier (maximum of 10 characters of text - letters or numbers). This allows faster searches for suppliers - rather than the full text of the supplier name - and keeps the size of the database at a minimum since it is referenced on all supplier transactions, purchase orders, shipments and supplier contacts. It is also used in the narrative of purchase order receipts.The system will force this code to be in capitals and will not allow the use of spaces, the ampersand (&), * or hypen - or inverted commas (").

Note: A supplier code can be altered retrospectively but because of the large scale of the changes required to the system to update stock movement transactions, purchase orders, supplier contacts and supplier transactions it could present a significant drain on resources. The option to change a supplier code is therefore in the utility menu Z_index.php - which must be entered as a manual URL and is only accessible by the system administrator. Such changes should only be undertaken when there are no other users on the system.

Supplier Name

The name of the supplier is used extensively in lookups. Proper capitalisation and use of the full name of the supplier is recommended. The maximum length of the name is 40 characters.

Address Line 1, 2, 3 and 4

This is the address of where invoices and statements are to billed from. These fields will allow a maximum of 40 characters and are optional.

Supplier Since

This defaults to the current date - at the location of the web-server. This is purely a memo field for use in externally generated reports. Any valid date of the format defined in config.php for DefaultDateFormat can be entered.

Bank Particulars, Bank Reference

These fields are used in the export of a payments file to a bank software payments system - these are the fields that a supplier will see as references on direct credits into their bank accounts. These fields accept up to 12 characters.

Bank Account Number

This is used in the export of a payments file to a bank software payments system. The bank account number is the account number where the funds will be transferred to when a payment run is processed. Bank Account Number accepts up to 16 characters.

Payment Terms

The payment terms are the terms under which trade with the supplier takes place. The appropriate payment terms can be selected from the drop down list. If necessary, new payment terms can be defined separately from Setup tab of the main menu under the receivables/payables section.

There are no restrictions on altering payment terms for a supplier at any time. The system records the due date for an invoice at the time of entry - the due date is defaulted based on the terms defined for the supplier at the time of entry. The due date can be overriden manually should a special arrangement on any particular invoice be required.

Supplier's Currency

This is a compulsory field that identifies the currency in which the supplier invoices. All invoices and debit notes entered for the supplier will use this currency and the rate will be defaulted in transaction entry from the rates set up in the currency table - accessible from the Setup tab under General. The currency rates should be maintained at least monthly.

Note: that the rate is recorded in the transaction not the currency. If a supplier changes the currency in which they are invoiced it is possible to allocate a new currency receipt against invoices (invoiced in the old currency) in which case the system will calculate large differences on exchange. Note: There is no error check on this and care should be taken, should this occur, to ensure invoices are matched off in the currency in which they were originally created - the cross rate between the new and old currency will provide an equivalent amount of the old currency for entry and allocation.

Remittance Advice

If the supplier is flagged as requiring a remittance advice the payment run will create a report showing the make up of the invoices and debit notes being paid by the payment.

This feature is not currently implemented.

Tax Group

The tax group determines the tax authorities to which the supplier reports and must collect taxes for. It is this field in conjunction with the inventory location record that determines the rates of tax used in the automatic calculation of tax on suppliers invoices and credits. These rates can be over-ridden at invoice entry time.

Selecting Suppliers (Vendors)

With most operations to operate on a specific supplier, the supplier must first be selected. This applies to any supplier inquiry as well as entry of purchase orders or purchase invoices or debit notes. It is the convention of KwaMoja to select the customer, item or supplier required before performing any function in these areas. For this reason the shortcut menu accross the top of every screen has links to each of these selection screens.
To select a supplier then - from any screen - click on Select Supplier, or press the ALT key and the number 4 key - in Internet Explorer one must press the Enter key also.

In common with the other selection screens the focus automatically goes to the supplier code where any character or series of characters of the supplier code can be entered. Having entered as much of the supplier code as is known click the "Search Now" button - this will then retrieve all the suppliers with this extract of text that occurs anywhere in the supplier code field.
If only one supplier is returned it is automatically selected for operating on. However if several suppliers exist with the same extract within their code they will be listed with their full name, currency and address. A button showing the code for each of the suppliers allows selection of the supplier required.
Instead of using the supplier code - if some of the supplier name is known this can be entered in the first field - labelled "Text in the NAME:" - the same procedure is followed as for entry of an extract of the supplier code.

Supplier Contacts

Any number of supplier contacts can be defined. This facility allows for ready access to phone numbers and email addresses of all company suppliers. Purchase orders created can be emailed directly to any of the defined contacts email addresses.

As with most operations to operate on a specific supplier, the supplier must first be selected. Once a supplier is selected the suppliers menu shows all the options available for operating on the supplier. Under maintenance click Modify/Delete Supplier Contact Details. The screen shows all the existing contacts already set up - any of these can be deleted by clicking the delete link to the right of their details. Existing details can be modified by clicking the edit link. The fields will be populated by the selected contacts details and available for modification. This screen allows entry of:

Supplier contacts entry provides a convenient place to store the key personnel at a supplier so others in the business know the functions of the individuals at the supplier. The email addresses are also used when sending supplier purchase orders - the actual contact to use is selectable from a list of supplier contacts.
It is not actually necessary to enter any details into the supplier contacts screen but advisable.

Entering Supplier Invoices

As with all transactions in KwaMoja the entity to be transacted with must first be selected i.e. a customer, item or supplier. Entering accounts payable transactions then requires the selection of a supplier first. Once a supplier is selected, the menu of options shows for the supplier among them "Enter an Invoice". The process below applies equally to entry of supplier credit notes as it does to entry of purchase invoices. In every case, entry of invoices and supplier credit notes (debit notes) requires entry of:

Invoice Date

This is the date from which KwaMoja determines the accounting period to create the general ledger postings for the transaction - should AP general ledger interface be activated. It is also the date from which, in conjunction with the supplier's payment terms the due date of the invoice is determined. This is used by the payment run to get all amounts due to a supplier for payment collated and listed. The system will use the information in the payment run to prepare a listing for producing a file of direct credits or printing cheques.

Invoice Reference

This is the supplier's invoice number or alpha reference uniquely identifying the invoice for the supplier. KwaMoja checks that the same supplier invoice reference is not entered previously and reports an error if it has - this is to prevent the duplicate entry of purchase invoices and potentially paying the supplier twice.

Invoice Exchange rate

This rate is used to convert the currency amounts entered on the invoice to the local currency and for the purposes of posting the invoice to the general ledger (in local currency) should the GL interface be active. This rate is recorded with the invoice and forms the basis of the calculation of differences on exchange against the rates entered against payments to the supplier. Note that differences on exchange are only calculated when the payments are allocated to the invoices. General ledger journals are created for differences on exchange also (if the AP->GL interface is active).

Comments

Comments are entirely optional. They appear in the supplier inquiry screen against the invoice.

Different Types Of Charges On A Purchase Invoice

Depending on the nature of the supplier's charge and the items purchased there are several choices as to how the amount of the invoice is entered.

Supplier invoices (and credit notes) can be entered for any or all of the choices together.

Creditors GL Interface

If the GL interface to creditors is not set to yes in the company preferences screen then the total amount of the invoice can be entered directly. There is a check though to ensure that the total of the charges entered against purchase orders, shipments, contracts and gl is less than the total invoice amount entered directly. If the amount entered is less than the sum of the charges then a warning shows. However, if the GL interface is active the total of the charges against purchase orders, contracts, fixed assets, gl and shipments is accumulated into the main invoice entry screen amount of the invoice.

Entry of Charges for Stock/Inventory Items

All stock items must be received into stock against a purchase order. In the process a GRN (goods received note) entry created. Goods received will be evidenced in KwaMoja by the stock movements inquiry showing the receipt of stock and also by the creation of a GRN against the supplier. If the general ledger interface is active a liability is posted to the GRN suspense account (defined in the company record) and the stock value is increased by the standard cost of the item at the time it is entered as received. The purchase order inquiry will also show the quantity received of the item (against the order). Entering a purchase invoice for stock items requires that the GRN records created for each item being charged for be matched off against the invoice. A special screen is available to search the GRNs outstanding for the supplier. This screen can be accessed directly from the invoice entry screen by clicking the button to enter against stock items.

The list of all the outstanding GRNs is shown together with any quantity already invoiced (on other invoices) and the price at which the purchase order was entered. The actual (currency) price that the supplier charged should be entered and the number of the items being invoiced on this invoice should be entered against the GRN too. This allows the actual charge for the item to be recorded against the GRN. Ultimately when the invoice is posted the actual cost (as converted at the invoice exchange rate)is recorded against the stock movement inquiry. When the invoice is entered, any for all GRNs matched to invoice charges, the purchase price variance calculated and posted to the general ledger (if the GL interface is active).

Entry of Invoices for Shipment Charges

Shipment charges for freight, duty and cartage that the business wishes to cost into the purchase price of stock items must be entered against shipments. Shipments accumulate all these costs together before apportioning them to the items in the shipment and calculating the approriate purchase price variance. The button "Enter Against Shipments" shows a new screen that allows existing shipments to be selected and amounts (in currency of the supplier) entered against each shipment. If the shipment reference is already known it can be entered directly.

If there are some charges that relate to stock items and some charges that relate to shipments then the total of both is accumulated into the invoice total.

Entry of General Ledger Charges

Purchase invoice entry looks a little different depending on whether the GL link to Account Payable is enabled or not (See Setup tab -> Company Preferences). If the GL interface is NOT enabled then there is simply a field to enter the total amount of the invoice into. If the GL interface is enabled then a third button shows "Enter General Ledger Analysis" - the total of all the general ledger analysis, the shipment costs and the entries against GRNs is accumulated into the total invoice charge and there is no opportunity to enter an invoice total amount anywhere - it is derived as the total of all the defined charges on the invoice.

Clicking on the button to "Enter General Ledger Analysis" opens a further screen that allows a general ledger code to be specified and an amount to be posted to this code and any narrative that is to appear in the GL against this charge. The general ledger code to charge can be selected from either the drop down box or entered directly. It is possible to enter negative amounts that would credit the general ledger account specified where there may be some rebate perhaps for returned pallets or part-exchange amount on the invoice. There is no limit to the number of general ledger accounts that the charge can be analysed against.

Purchase Invoice Tax

The tax due to a supplier on the entry of a supplier's invoice is (by default) calculated automatically according to the following rules:

If the automatic calculations above do not work out the tax amounts can be entered manually for each of the tax authorities relevant to the supplier. To enter tax manually, there is a selection box with a choice to calculate tax manually or automatically, select manual, then click on the "Change Tax Calculation Method" button - now the rates from the automatic calculation dissappear and input box(es) for the percentage(s) are available for each tax authority.

Committing A Purchase Invoice

Clicking on "Enter Invoice" immediately processes the invoice against the supplier's account, creates the necessary general ledger transactions, updates the GRNs and the purchase orders for quantities invoiced and creates shipment charges records as required. Zero charge purchase invoices cannot be entered - the system checks to ensure there are at least some charges on the invoice. It also checks to ensure a reference and date is entered. As with all transaction entry in KwaMoja there is no subsequent processing required for all the information to be fully up to date it is all done at the time of clicking this button.

General Ledger Postings On Purchase Invoices

This section might be a little complex. However, understanding what is happening in the general ledger and implications of purchase invoice entries in the general ledger is necessary inorder to understand how to reconcile the various accounts.

Each of the three types of entries in a purchase invoice are posted to the general ledger in different ways:

Inventory Costing and GL Postings

The Outsanding Goods Received report shows the calculation of the cost of goods received but not yet invoiced. This calculation is done using the standard cost as it is this figure that is used for the posting to the GL at the time the goods are received. Note that the "standard cost" field is actually the weighted average cost if you are using the weighted average cost method. The standard cost should be reflective of the purchase cost in FX as converted to local currency plus all landing costs. The FX cost as converted to local currency will of course exclude any landing costs and obviously it will be different each time the currency rates of exchange are updated.

Variances are only taken to the GL based on the comparison of the standard cost (at the time the goods were received) compared to what the purchase invoice at the rate used during the purchase invoice entry. If weighted average costing is used then actually the variance is taken to the value of inventory and the unit weighted average cost is updated to reflect the new value.

Exchange differences subsequent i.e. when the purchase invoice is paid is taken to exchange differences and not against the cost of the items that were purchased.

Supplier Payments

Entering accounts payable transactions requires the selection of a supplier first. Once a supplier is selected, the menu of options shows for the supplier among them "Enter A Payment To The Supplier". The currency of the payment is deemed to be in the currency of the supplier - from the supplier record. This currency will show on the payment entry screen.

In every case, entry of a supplier payment requires entry of:

Bank Account Selection

The choice of bank accounts from which the payment is being made is shown in a select box. KwaMoja does not support multi-currency bank accounts so the exchange rate will always be the rate to purchase the currency of the supplier against the business's functional currency. The bank account selected will have a record created for the payment and if the general ledger link is enabled the postings will be made from the general ledger code stored against this bank account. Bank accounts are defined from the Setup tab -> Bank Accounts - under the General column of options.

Payment Date

This is the date from which KwaMoja determines the accounting period to create the general ledger postings for the transaction - should AP general ledger interface be activated. This is the date that will show on supplier transaction inquiries and the bank account transaction listings.

Reference

Any text up to 50 characters long

Exchange rate

This rate is used to purchase the currency amount being paid to the supplier. This rate is recorded with the payment and forms the basis of the calculation of differences on exchange against the rates entered against invoices to the supplier. Note that differences on exchange are only calculated when payments are allocated to invoices.

Supplier Narrative

The supplier narrative in general ledger transactions. If blank, it uses the bank narrative. This information is to be displayed in a general ledger transactions inquiry. The maximum number of characters allowed in the this element is 200.

Supplier Reference

The supplier reference in supplier transactions. If blank, it uses the payment type. This information is to be displayed in a supplier transactions inquiry. The maximum number of characters allowed in the this element is 20.

Transaction Text

The transaction text in supplier transactions. If blank, it uses the narrative. This information is to be displayed in a supplier transactions inquiry. The maximum number of characters allowed in the this element is 200.

Amount of Payment

The amount in foreign currency being paid to the supplier. The general ledger entries made (if the link is enabled) debit the suppliers control account - specified in the company preferences record (Setup tab -> Company Preferences) and credit the bank account selected above.

Amount of Discount

The amount in foreign currency being allowed to the supplier as payment discount. General ledger entries are created (if the link is enabled) to the account specified for "Prompt Payment Discount" in the Company Preferences record. If discount is to posted some other way then it is better to create a dummy item for the discount given and enter credit notes for the dummy item with posting as defined in the Sales GL Interface setup.