From Vendor Bill to Payment

From Vendor Bill to Payment

Once vendor bills are registered in KIU BMP, you can easily pay vendors for the correct amount and at the right time (not too late, not too early; depending on your vendor policy). KIU BMP also offers reports to track your aged payable balances.

If you want to control vendor bills received from your vendors, you can use the KIU BMP Purchase application that allows you to control and pre-complete them automatically based on past purchase orders.

From Vendor Bill to Payment

Record a new vendor bill

When a vendor bill is received, you can record it from Purchases ‣ Vendor Bills in the Accounting application. Some more in depth criteria book of ra online from intriquing,notable and useful information. As a shortcut, you can also use the New Bill feature on the accounting dashboard.

To register a new vendor bill, start by selecting a vendor and inputting their invoice as the Vendor Reference, then add and confirm the product lines, making sure to have the right product quantities, taxes and prices.

Save the invoice to update the pre tax and tax amounts at the bottom of the screen. You will most likely need to configure the prices of your products without taxes as KIU BMP will compute the tax for you.

Validate The Vendor Bill

Once the vendor bill is validated, a journal entry will be generated based on the configuration on the invoice. This journal entry may differ depending on the the accounting package you choose to use.

For most European countries, the journal entry will use the following accounts:

  • Accounts Payable: defined on the vendor form
  • Taxes: defined on the products and per line
  • Expenses: defined on the line item product used

For Anglo-Saxon (US) accounting, the journal entry will use the following accounts:

  • Accounts Payable: defined on the vendor form
  • Taxes: defined on the products and per line
  • Goods Received: defined on the product form

You can check your Profit & Loss or the Balance Sheet reports after having validated a couple of vendor bills to see the impact on your general ledger.

Pay a bill

To create a payment for an open vendor bill directly, you can click on Register a Payment at the top of the form.

From there, you select the payment method (i.e. Checking account, credit card, check, etc…) and the amount you wish to pay. By default, KIU BMP will propose the entire remaining balance on the bill for payment. In the memo field, we recommend you set the vendor invoice number as a reference (KIU BMP will auto fill this field from the from the vendor bill if set it correctly).

 Note

You can also register a payment to a vendor directly without applying it to a vendor bill. To do that, Purchases ‣ Payments. Then, from the vendor bill you will be able to reconcile this payment with directly.

 

Reporting

Aged payable balance

In order to get a list of open vendor bills and their related due dates, you can use the Aged Payable report, under the reporting menu, (in Reporting ‣ Business Statement ‣ Aged payable) to get a visual of all of your outstanding bills.

From here, you can click directly on a vendors name to open up the details of all outstanding bills and the amounts due, or you can annotate any line for managements information. At any point in time while you’re looking through the report, you can print directly to Excel or PDF and get exactly what you see on the screen.

 

8.2.1. From Customer Invoice to Payments Collection

KIU BMP supports multiple invoicing and payment workflows, so you can choose and use the ones that match your business needs. Whether you want to accept a single payment for a single invoice, or process a payment spanning multiple invoices and taking discounts for early payments, you can do so efficiently and accurately.

From Draft Invoice to Profit and Loss

If we pick up at the end of a typical ‘order to cash’ scenario, after the goods have been shipped, you will: issue an invoice; receive payment; deposit that payment at the bank; make sure the Customer Invoice is closed; follow up if Customers are late; and finally present your Income on the Profit and Loss report and show the decrease in Assets on the Balance Sheet report.

Invoicing in most countries occurs when a contractual obligation is met. If you ship a box to a customer, you have met the terms of the contract and can bill them. If your supplier sends you a shipment, they have met the terms of that contract and can bill you. Therefore, the terms of the contract is fulfilled when the box moves to or from the truck. At this point, KIU BMP supports the creation of what is called a Draft Invoice by Warehouse staff.

Invoice creation

Draft invoices can be manually generated from other documents such as Sales Orders, Purchase Orders,etc. Although you can create a draft invoice directly if you would like.

An invoice must be provided to the customer with the necessary information in order for them to pay for the goods and services ordered and delivered. It must also include other information needed to pay the invoice in a timely and precise manner.

Draft invoices

The system generates invoice which are initially set to the Draft state. While these invoices

remain unvalidated, they have no accounting impact within the system. There is nothing to stop users from creating their own draft invoices.

Let’s create a customer invoice with following information:

  • Customer: Azure Interior
  • Product: iMac
  • Quantity: 1
  • Unit Price: 100

The document is composed of three parts:

  • the top of the invoice, with customer information,
  • the main body of the invoice, with detailed invoice lines,
  • the bottom of the page, with detail about the taxes, and the totals.

Open or Pro-forma invoices

An invoice will usually include the quantity and the price of goods and/or services, the date, any parties involved, the unique invoice number, and any tax information.

“Validate” the invoice when you are ready to approve it. The invoice then moves from the Draft state to the Open state.

When you have validated an invoice, KIU BMP gives it a unique number from a defined, and modifiable, sequence.

Accounting entries corresponding to this invoice are automatically generated when you validate the invoice. You can see the details by clicking on the entry in the Journal Entry field in the “Other Info” tab.

Send the invoice to customer

After validating the customer invoice, you can directly send it to the customer via the ‘Send by email’ functionality.

Payment

In KIU BMP, an invoice is considered to be paid when the associated accounting entry has been reconciled with the payment entries. If there has not been a reconciliation, the invoice will remain in the Open state until you have entered the payment.

A typical journal entry generated from a payment will look like as follows:

Account

Partner

Due date

Debit

Credit

Bank

Azure Interior

 

115

 

Accounts Receivable

Azure Interior

   

115

Receive a partial payment through the bank statement

You can manually enter your bank statements in KIU BMP, or you can import them in from a csv file or from several other predefined formats according to your accounting localization.

Create a bank statement from the accounting dashboard with the related journal and enter an amount of $100 .

Reconcile

Now let’s reconcile!

You can now go through every transaction and reconcile them or you can mass reconcile with instructions at the bottom.

After reconciling the items in the sheet, the related invoice will now display “You have outstanding payments for this customer. You can reconcile them to pay this invoice. “

Apply the payment. Below, you can see that the payment has been added to the invoice.

 

Profit and loss

The Profit and Loss statement displays your revenue and expense details. Ultimately, this gives you a clear image of your Net Profit and Loss. It is sometimes referred to as the “Income Statement” or “Statement of Revenues and Expenses.”

Balance sheet

The balance sheet summarizes your company’s liabilities, assets and equity at a specific moment in time.

For example, if you manage your inventory using the perpetual accounting method, you should expect a decrease in account “Current Assets” once the material has been shipped to the customer.

 

The Accounting behind KIU BMP

This page summarises the way KIU BMP deals with typical accounts and transactions.

Double-entry bookkeeping

KIU BMP automatically creates all the behind-the-scenes journal entries for each of your accounting transactions: customer invoices, point of sale order, expenses, inventory moves, etc.

KIU BMP uses the rules of double-entry bookkeeping system: all journal entries are automatically balanced (sum of debits = sum of credits).

Accrual and Cash Basis Methods

KIU BMP supports both accrual and cash basis reporting. This allows you to report income / expense at the time transactions occur (i.e., accrual basis), or when payment is made or received (i.e., cash basis).

Multi-companies

KIU BMP allows one to manage several companies within the same database. Each company has its own chart of accounts and rules. You can get consolidation reports following your consolidation rules.

Users can access several companies but always work in one company at a time.

Multi-currencies

Every transaction is recorded in the default currency of the company. For transactions occurring in another currency, KIU BMP stores both the value in the currency of the company and the value in the currency of the transaction. KIU BMP can generate currencies gains and losses after the reconciliation of the journal items.

Currency rates are updated once a day using a yahoo.com online web-service.

International Standards

KIU BMP accounting supports more than 50 countries. The KIU BMP core accounting implements accounting standards that are common to all countries. Specific modules exist per country for the specificities of the country like the chart of accounts, taxes, or bank interfaces.

In particular, KIU BMP’s core accounting engine supports:

  • Anglo-Saxon Accounting (U.S., U.K.,, and other English-speaking countries including Ireland, Canada, Australia, and New Zealand) where costs of good sold are reported when products are sold/delivered.
  • European accounting where expenses are accounted at the supplier bill.

KIU BMP has modules to comply with IFRS rules.

Accounts Receivable & Payable

By default, KIU BMP uses a single account for all account receivable entries and one for all accounts payable entries. You can create separate accounts per customers/suppliers, but you don’t need to.

As transactions are associated to customers or suppliers, you get reports to perform analysis per customer/supplier such as the customer statement, revenues per customers, aged receivable/payables, …

Wide range of financial reports

In KIU BMP, you can generate financial reports in real time. KIU BMP’s reports range from basic accounting reports to advanced management reports. KIU BMP’s reports include:

  • Performance reports (such as Profit and Loss, Budget Variance)
  • Position reports (such as Balance Sheet, Aged Payables, Aged Receivables)
  • Cash reports (such as Bank Summary)
  • Detail reports (such as Trial Balance and General Ledger)
  • Management reports (such as Budgets, Executive Summary)

KIU BMP’s report engine allows you to customize your own report based on your own formulae.

Import bank feeds automatically

Bank reconciliation is a process that matches your bank statement lines, as supplied by the bank, to your accounting transactions in the general ledger. KIU BMP makes bank reconciliation easy by frequently importing bank statement lines from your bank directly into your KIU BMP account. This means you can have a daily view of your cashflow without having to log into your online banking or wait for your paper bank statements.

KIU BMP speeds up bank reconciliation by matching most of your imported bank statement lines to your accounting transactions. KIU BMP also remembers how you’ve treated other bank statement lines and provides suggested general ledger transactions.

Calculate the tax you owe your tax authority

KIU BMP totals all your accounting transactions for your tax period and uses these totals to calculate your tax obligation. You can then check your sales tax by running KIU BMP’s Tax Report.

Inventory Valuation

KIU BMP support both periodic (manual) and perpetual (automated) inventory valuations. The available methods are standard price, average price, LIFO (for countries allowing it) and FIFO.

Easy retained earnings

Retained earnings are the portion of income retained by your business. KIU BMP automatically calculates your current year earnings in real time so no year-end journal or rollover is required. This is calculated by reporting the profit and loss balance to your balance sheet report automatically.

 

Introduction to KIU BMP Accounting

KIU BMP is beautiful accounting software designed for the needs of the 21st century.

KIU BMP connects directly to your bank or paypal account. Transactions are synchronized every hour and reconciliation is blazing fast. It’s like magic.

Instantly create invoices and send them with just a click. No need to print them.

KIU BMP can send them for you by email or regular mail.

Your customers pay online, meaning you get your money right away.

KIU BMP accounting is connected with all KIU BMP our apps such as sale, purchase, inventory and subscriptions.

This way, recording vendor bills is also super quick. Set a vendor, select the purchase order and KIU BMP fills in everything for you automatically.

 

It’s that easy with KIU BMP.

Wait, there is more. You will love the KIU BMP reports. From legal statements to executive summaries, they are fast and dynamic. Use KIU BMP’s business intelligence feature to navigate through all your companies data.

Of course, KIU BMP is mobile too. You can use it to check your accounts on the go.

 

7.10.2. How to invoice the shipping cost to the customer?

  • Configuration:

To configure the price of your delivery methods, go to the Inventory app, click on Configuration ‣ Delivery ‣ Delivery Methods. You can manually set a price for the shipping: It can be fixed or based on rules.

  • Invoice the price set on the sale order

On your sale order, choose the carrier that will be used. Click on Delivery Method to choose the right one.

The price is computed when you save the sale order or when you click on Set price.

To invoice the price of the delivery charge on the sale order, click on Set price, it will add a line with the name of the delivery method as a product. It may vary from the real price.

When you create the invoice, it will take the price set on the sale order.

7.10.1. How To Set up a Delivery Method?

Kiu BMP can handle various delivery methods, but it is not activated by default. Delivery methods can be used for your sale orders, your deliveries but also on your e-commerce. Delivery methods allow you to manage the transport company, the price and the destination. You can even integrate Kiu BMP with external shippers to compute the real price and the packaging.

  • Configuration:

Go to Inventory -> Configuration -> Delivery methods. Enter the name and set the price, it can be fixed or based on rules

  • If the price is fixed, tick Fixed price. You’ll just have to define the price. If you want the delivery to be free above a certain amount, tick the option Free if Order total is more than and set a price.
  • If the price varies according to rules, tick Based on Rules. Click on add an item to a pricing rule. Choose a condition based on either the weight, the volume, the price or the quantity.

Finally you can limit the delivery method to a few destinations. The limit can be applied to some countries, states or even zip codes. This feature limits the list of countries on your e-commerce.

  • Delivery Process:

Go to Sales -> Sales -> Sale order. You can now choose the Delivery Method on your sale order. If you want to invoice the price of the delivery charge on the sale order, click on Set price, it will add a line with the name of the delivery method as a product.

Go to Inventory -> Dashboard -> Delivery orders

You can add or change the delivery method on the delivery itself. On the delivery, check the Carrier Information. The carrier is the chosen delivery method.

7.9.3. How To Do An Inventory Valuation?(Anglo-Saxon Accounting)

  • Periodic Inventory Valuation

In a periodic inventory valuation, goods reception and outgoing shipments have no direct impact in the accounting. At the end of the month or year, the accountant posts one journal entry representing the value of the physical inventory.

At the end of the month/year, your company does a physical inventory or just relies on the inventory in Kiu BMP to value the stock into your books. Then you need to break down the purchase balance into both the inventory and the cost of goods sold using the following formula:

Cost of goods sold (COGS) = Starting inventory value + Purchases – Closing inventory value

  • Perpetual Inventory Valuation.

In a perpetual inventory valuation, goods receptions and outgoing shipments are posted in your books in real time. The books are therefore always up-to-date. This mode is dedicated to expert accountants and advanced users only. As opposed to periodic valuation, it requires some extra configuration & testing

Configuration:

  • Accounts Receivable/Payable: defined on the partner (Accounting tab)
  • Deferred Tax Assets/Liabilities: defined on the tax used on the invoice line
  • Revenues: defined on the product category as a default, or specifically to a specific product.
  • Expenses: this is where you should set the “Cost of Goods Sold” account. Defined on the product category as a default value, or specifically on the product form.
  • Goods Received Not Purchased: to set as Stock Input Account in product’s internal category
  • Goods Issued Not Invoiced: to set as Stock Output Account in product’s internal category
  • Inventory: to set as Stock Valuation Account in product’s internal category
  • Price Difference: to set in product’s internal category or in product form as a specific replacement value

7.9.2. How to do an inventory valuation? (Continental Accounting)

–          Periodic Inventory Valuation

In a periodic inventory valuation, goods reception and outgoing shipments have no direct impact in the accounting. At the end of the month or year, the accountant posts one journal entry representing the value of the physical inventory.

–          Perpetual Inventory Valuation

In a perpetual inventory valuation, goods receptions and outgoing shipments are posted in your books in real time. The books are therefore always up-to-date. This mode is dedicated to expert accountants and advanced users only. As opposed to periodic valuation, it requires some extra configuration & testing.

Configuration:

  • Accounts Receivable/Payable: defined on the partner (Accounting tab)
  • Deferred Tax Assets/Liabilities: defined on the tax used on the invoice line
  • Revenues/Expenses: defined by default on product’s internal category; can be also set in product form (Accounting tab) as a replacement value.
  • Inventory Variations: to set as Stock Input/ Output Account in product’s internal category
  • Inventory: to set as Stock Valuation Account in product’s internal category

7.9.1. Overview

Every year your inventory valuation has to be recorded in your balance sheet. This implies two main choices:

  • The way you compute the cost of your stored items (Standard vs. Average vs. Real Price);
  • The way you record the inventory value into your books (periodic vs. Perpetual).

Standard Price means you estimate the cost price based on direct materials, direct labor and manufacturing overhead at the end of a specific period (usually once a year). You enter this cost price in the product form.

The Average Price method recompute the cost price as a receipt order has been processed, based on prices defined in tied purchase orders. The average cost does not change when products leave the warehouse.

From an accounting point of view, this method is mainly justified in case of huge purchase price variations and is quite unusual due to its operational complexity. Your actually need a software like Kiu BMP to easily keep this cost up-to-date.

This method is dedicated to advanced users. It requires well established business processes because the order in which you process receipt orders matters in the cost computation.

For Real Price (FIFO, FEFO, etc), the costing is further refined by the removal strategy set on the warehouse location or product’s internal category. The default strategy is FIFO. With such method, your inventory value is computed from the real cost of your stored products and not from the cost price shown in the product form. Whenever you ship items, the cost price is reset to the cost of the last items shipped. This cost price is used to value any product not received from a purchase order

FIFO is advised if you manage all your workflow into Kiu BMP (Sales, Purchases, Inventory). It suits any kind of users.

Kiu BMP  allows any method. To change it, check Use a ‘Fixed’, ‘Real’ or ‘Average’ price costing method in Purchase settings. Then set the costing method from products’ internal categories. Categories show up in the Inventory tab of the product form.

Whatever the method is, Kiu BMP provides a full inventory valuation in Inventory ‣ Reports ‣ Inventory Valuation .

7.8.3. How to manage lots of identical products?

Lots are useful for products you receive in great quantity and for which a lot number can help in reporting, quality controls, or any other info. Lots will help identify a number of pieces having for instance a production fault. It can be useful for a batch production of clothes or food.

Kiu BMP  has the capacity to manage lots ensuring compliance with the traceability requirements imposed by the majority of industries.

  • Configuration:

You need activate the tracking of lots in the settings. Go to Inventory -> Configuration ‣ Settings, select Track lots or serial numbers

In order to have an advanced management of the lots, you should also select Manage several warehouses, each one composed by several stock locations. Then click on Apply

  • Operation types configuration:

You also need to set up how you will manage lots for each operations. Go to Inventory -> Configuration -> Operation types

For each type (receipts, internal transfers, deliveries,…), you can set if you can create new lot numbers or only use existing lot numbers.

  • Product configuration:

Go into Inventory Control ‣ Products, and open the product of your choice. Click on Edit, and in the Inventory tab, select Tracking by Lots, then click on Save.

  • Manage lots:
  • Transfer:

In order to process a transfer of a product tracked by lot, you have to input the lot number(s).

Click on the lot icon :

A window will pop-up. Click on Add an item and fill in the lot number and the quantity.

Depending on your operation type configuration, you will be able to fill in new lot numbers, or only use existing ones.

  • Inventory adjustment

Inventory of a product tracked by lot can be done in 2 ways:

  • Classic inventory by products
  • Inventory of a lot

When doing a classic inventory, there is a Serial Number column. If the product has already been assigned with a number, it is already pre-filled.

Click on Add an item if the product has not been inventoried yet. You can easily create lots, just type in a new lot number in the column.

You can also just do the inventory of a lot. In this case, you will have to fill in the Lot number. You can also create a new lot from here. Just type in the number, a window will pop out to link the number to a product.

  • Lots traceability:

You can check the lot traceability from Inventory ‣ Inventory Control ‣ Lots/Serial Numbers