Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
accounting_ch_09-bills_from_vendors [2019/01/30 09:21] 127.0.0.1 external edit |
accounting_ch_09-bills_from_vendors [2019/01/30 12:33] kcifreo |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | |||
- | |||
- | |||
- | |||
Another feature of the accounting module is the ability to manage bills, or invoices, out of Control. Similar to other accounting software packages, you can enter bills, create them from purchase orders, and pay bills as well. | Another feature of the accounting module is the ability to manage bills, or invoices, out of Control. Similar to other accounting software packages, you can enter bills, create them from purchase orders, and pay bills as well. | ||
- | + | ===== Purpose and Use ===== | |
- | + | ||
- | Purpose and Use | + | |
- | + | ||
Every company has bills; we all have to pay the electric bill and buy office supplies. The purpose of a bill is to request payment for goods or services previously supplied. | Every company has bills; we all have to pay the electric bill and buy office supplies. The purpose of a bill is to request payment for goods or services previously supplied. | ||
- | |||
- | |||
Your company must have Payables and Bills enabled in System Setup to access this feature. | Your company must have Payables and Bills enabled in System Setup to access this feature. | ||
- | + | ===== Creating | |
- | + | ||
- | Creating | + | |
- | + | ||
To enter a new bill, select File > New > New Bill or Vendor > New > New Bill. On the Items tab, you can then fill in the Vendor name, date of bill, description, | To enter a new bill, select File > New > New Bill or Vendor > New > New Bill. On the Items tab, you can then fill in the Vendor name, date of bill, description, | ||
- | |||
- | |||
You can also convert a Purchase Order into a Bill. Open the purchase order and click the Convert > Convert To Bill button on the right. Any information that was filled in on the purchase order will transfer to the bill; however, you may need to change some fields on the bill, such as unit cost or shipping charge. You will also need to enter an Expense Account if one was not entered on the purchase order; this is a required field on a Bill, but not on a purchase order. Once you have all the information filled in, click Save to save the bill. | You can also convert a Purchase Order into a Bill. Open the purchase order and click the Convert > Convert To Bill button on the right. Any information that was filled in on the purchase order will transfer to the bill; however, you may need to change some fields on the bill, such as unit cost or shipping charge. You will also need to enter an Expense Account if one was not entered on the purchase order; this is a required field on a Bill, but not on a purchase order. Once you have all the information filled in, click Save to save the bill. | ||
- | + | ===== GL Detail | |
- | + | ||
- | GL Detail | + | |
**Scenario: | **Scenario: | ||
- | |||
- | |||
You receive a bill for $500 plus $50 in taxes from the Giant Supplier Company. The bill is for $100 in grommets, which are expensed, and $350 in paper which is accrued, and $50 in shipping. The initial GL entries for the order you have created will look like: | You receive a bill for $500 plus $50 in taxes from the Giant Supplier Company. The bill is for $100 in grommets, which are expensed, and $350 in paper which is accrued, and $50 in shipping. The initial GL entries for the order you have created will look like: | ||
+ | |**Account** ||**Debit** ||**Credit** ||**Notes** || | ||
+ | |Accounts Payable|| | ||
+ | |Grommet Expenses||100.00|| | ||
+ | |Paper Inventory||350.00|| | ||
+ | |Shipping Expenses||50.00|| | ||
+ | When the bill is paid, these GL entries will be posted: | ||
- | || **Account** || **Debit** || **Credit** | + | |**Account** ||**Debit** ||**Credit** |
- | || Accounts Payable || | + | |Accounts Payable||550.00|| |
- | || Grommet Expenses || 100.00 || || This expense account records the charges for the specified material. || | + | |Bank Account|| |
- | || Paper Inventory || 350.00 || || Accrue the value of this in the inventory asset account for the specified material. || | + | |
- | || Shipping Expenses || 50.00 || || This expense account records the charges for shipping. This may be setup as different parts or entered directly. || | + | |
- | When the bill is paid, these GL entries will be posted: \\ || **Account** || **Debit** || **Credit** | + | |
- | || Accounts Payable || 550.00 || || Decrease the outstanding obligation. || | + | |
- | || Bank Account || || 550.00 || Easy come, easy go. || | + | |
- | Making Vendor Payments | + | |
+ | ===== Making Vendor Payments ===== | ||
To pay bills from your vendors, choose Banking > Pay Bills. A list of open bills will appear, and you will be able to select the ones you want to pay. You can then choose the payment date (the current date is the default), the payment type, and the bank account you are paying bills out of. If the payment type is by Check, you must also choose whether you will assign the check numbers or if the checks will be printed. Once you have all the options filled in, click the Pay button to the right. If you decide to pay bills at a later time, simply click Cancel, and no bills will be paid; the system will ask you to confirm a cancellation. | To pay bills from your vendors, choose Banking > Pay Bills. A list of open bills will appear, and you will be able to select the ones you want to pay. You can then choose the payment date (the current date is the default), the payment type, and the bank account you are paying bills out of. If the payment type is by Check, you must also choose whether you will assign the check numbers or if the checks will be printed. Once you have all the options filled in, click the Pay button to the right. If you decide to pay bills at a later time, simply click Cancel, and no bills will be paid; the system will ask you to confirm a cancellation. | ||
- | |||
- | |||
To pay one bill, open Bill Explorer and select the bill you want to pay and open it, then click the Deposits/ | To pay one bill, open Bill Explorer and select the bill you want to pay and open it, then click the Deposits/ | ||
- | + | ===== Writing/ | |
- | + | ||
- | Writing/ | + | |
- | + | ||
Sometimes, you will write checks for items or services and then will need to enter them in Control. To enter a check that's already been written, enter the charge as a New Bill and save; the Quick Bill Payment will appear and you can enter the check number, date, and amount, and click OK to apply. | Sometimes, you will write checks for items or services and then will need to enter them in Control. To enter a check that's already been written, enter the charge as a New Bill and save; the Quick Bill Payment will appear and you can enter the check number, date, and amount, and click OK to apply. | ||
+ | {{: | ||
+ | For information about check formats supported by Control' | ||
- | {{:: | + | ===== Cash Payments |
- | + | ||
- | + | ||
- | + | ||
- | For information about check formats supported by Control' | + | |
- | + | ||
- | + | ||
- | + | ||
- | Cash Payments | + | |
- | + | ||
Paying bills with cash is done similar to paying by check. Choose Banking > Pay Bills, select the bills you want to pay, choose the payment date, and select Cash as Payment Type at the bottom of the screen. | Paying bills with cash is done similar to paying by check. Choose Banking > Pay Bills, select the bills you want to pay, choose the payment date, and select Cash as Payment Type at the bottom of the screen. | ||
- | + | ===== Paying By Credit Card ===== | |
- | + | ||
- | Paying By Credit Card | + | |
- | + | ||
Paying bills by credit card is done similar to paying by check. Choose Banking > Pay Bills, select the bills you want to pay, choose the payment date, and select Credit Card as Payment Type at the bottom of the screen. Your company may have more than one credit card, so be sure to select the correct card to use for payment. | Paying bills by credit card is done similar to paying by check. Choose Banking > Pay Bills, select the bills you want to pay, choose the payment date, and select Credit Card as Payment Type at the bottom of the screen. Your company may have more than one credit card, so be sure to select the correct card to use for payment. | ||
- | + | ===== Voiding Payments | |
- | + | ||
- | Voiding Payments | + | |
- | + | ||
To void a payment that's been made on a bill, open the bill and go to the Activities tab. Locate the Payment activity you want to void, and double click; this will open a journal entry window with the payment information. Click the Void button on the right side of the screen; you will get a message stating that this may be part of a larger payment, and ask if you want to continue. Click Yes, and you will be asked for a reason for voiding this payment. We strongly recommend putting a detailed note for later reference. You can also right click on the bill payment activity and select Void to void a payment. | To void a payment that's been made on a bill, open the bill and go to the Activities tab. Locate the Payment activity you want to void, and double click; this will open a journal entry window with the payment information. Click the Void button on the right side of the screen; you will get a message stating that this may be part of a larger payment, and ask if you want to continue. Click Yes, and you will be asked for a reason for voiding this payment. We strongly recommend putting a detailed note for later reference. You can also right click on the bill payment activity and select Void to void a payment. | ||
- | + | ===== Vendor Credit Memos ===== | |
- | + | ||
- | Vendor Credit Memos | + | |
- | + | ||
Vendor Credit Memos (VCMs) are used to adjust the vendor credit balance in the vendor record. The vendor credit balance may then be applied to bills to offset the balance due. | Vendor Credit Memos (VCMs) are used to adjust the vendor credit balance in the vendor record. The vendor credit balance may then be applied to bills to offset the balance due. | ||
- | |||
- | |||
Vendor credit memos work like negative bills. That is, the amount entered on each line item will actually credit (decrease) the expense account rather than debit (increase) the expense account. The total amount will then be debited to a system asset account called " | Vendor credit memos work like negative bills. That is, the amount entered on each line item will actually credit (decrease) the expense account rather than debit (increase) the expense account. The total amount will then be debited to a system asset account called " | ||
- | + | {{: | |
- | + | ||
- | {{:: | + | |
- | + | ||
To add a new Vendor Credit Memo, click on the Vendors tab, select new, and click New Vendor Credit Memo. | To add a new Vendor Credit Memo, click on the Vendors tab, select new, and click New Vendor Credit Memo. | ||
- | |||
- | |||
Doing so will bring you to the screen below. This screen will allow the user to create a new vendor memo. | Doing so will bring you to the screen below. This screen will allow the user to create a new vendor memo. | ||
+ | {{: | ||
- | + | {{: | |
- | {{:: | + | |
- | + | ||
- | + | ||
- | + | ||
- | {{:: | + | |
- | + | ||
At the top of the screen, the user must select a Vendor to create the memo for. The user can also select a credit date. | At the top of the screen, the user must select a Vendor to create the memo for. The user can also select a credit date. | ||
- | |||
- | |||
The following must be entered on the line item: | The following must be entered on the line item: | ||
- | * **No.** This is the number of the line item. | ||
- | * **Item Type.** This displays the item type. | ||
- | * **Item Name.** This is the name of the item. | ||
- | * **Description.** This field displays the description of the item. | ||
- | * **Expense Account.** This is the expense account that the item uses. | ||
- | * **Qty.** This is the quantity of the item that is in stock. | ||
- | * **Qty Billed.** This is the quantity of the item that has been billed. | ||
- | * **Units.** This displays the unit that the part comes in. | ||
- | * **Unit Cost.** This is the item's cost per unit. | ||
- | * **Total Cost.** This is the total cost for the part. | ||
- | * **SKU.** A code number assigned to an item for inventory. | ||
- | * **Packing Size.** This displays the packing size for the item. | ||
- | |||
- | |||
+ | * **No.** | ||
+ | * **Item Type.** | ||
+ | * **Item Name.** | ||
+ | * **Description.** | ||
+ | * **Expense Account.** | ||
+ | * **Qty.** | ||
+ | * **Qty Billed.** | ||
+ | * **Units.** | ||
+ | * **Unit Cost.** | ||
+ | * **Total Cost.** | ||
+ | * **SKU.** | ||
+ | * **Packing Size.** | ||
There is also a box to type a memo on the credit memo and a place to insert a reference number. | There is also a box to type a memo on the credit memo and a place to insert a reference number. | ||
+ | **Vendor Tab** | ||
- | + | {{: | |
- | Vendor Tab | + | |
- | + | ||
- | + | ||
- | + | ||
- | {{:: | + | |
- | + | ||
Clicking on the Vendor Tab will display information about the vendor. The Vendor' | Clicking on the Vendor Tab will display information about the vendor. The Vendor' | ||
- | |||
- | |||
The Vendor' | The Vendor' | ||
+ | **Totals/ | ||
- | + | {{: | |
- | Totals/ | + | |
- | + | ||
- | + | ||
- | + | ||
- | {{:: | + | |
- | + | ||
On this tab, the name of the employee that entered the memo is shown. The selected due date is also shown. | On this tab, the name of the employee that entered the memo is shown. The selected due date is also shown. | ||
- | |||
- | |||
Also the payment terms and payment information is displayed. | Also the payment terms and payment information is displayed. | ||
+ | The Vendor Credit Memo Total is broken down into the following: | ||
- | |||
- | The Vendor Credit Memo Total is broken down into the following: | ||
* Parts total | * Parts total | ||
* Expenses total | * Expenses total | ||
* Line Item total | * Line Item total | ||
* Taxes | * Taxes | ||
- | |||
- | |||
At the bottom of the window, there 2 separate note boxes. The first box is for Purchase Order notes. The second box is for Internal Notes that will not appear on the purchase order. | At the bottom of the window, there 2 separate note boxes. The first box is for Purchase Order notes. The second box is for Internal Notes that will not appear on the purchase order. | ||
+ | **Activities Tab** | ||
- | + | {{: | |
- | Activities Tab | + | |
- | + | ||
- | + | ||
- | + | ||
- | {{:: | + | |
- | + | ||
This tab allows the user to look at activities. On this screen, the user has the option to select which activities should be tracked. There are 48 activities that can be tracked, including scheduled queries, payroll, and deposit made. The user can choose to track all activities or only certain ones by checking the corresponding boxes next to the activity. | This tab allows the user to look at activities. On this screen, the user has the option to select which activities should be tracked. There are 48 activities that can be tracked, including scheduled queries, payroll, and deposit made. The user can choose to track all activities or only certain ones by checking the corresponding boxes next to the activity. | ||
+ | For each activity that is tracked, the following will be displayed: | ||
- | |||
- | For each activity that is tracked, the following will be displayed: | ||
* Class. The class the activity belongs to. | * Class. The class the activity belongs to. | ||
* Date. The date the activity began. | * Date. The date the activity began. | ||
Line 224: | Line 134: | ||
* Voided. If the box is checked, the employee voided the activity. | * Voided. If the box is checked, the employee voided the activity. | ||
+ | ===== Bill Early Payment and Other discounts ===== | ||
- | + | Some vendors allow for a discount to be taken for early payment on a bill. This **early payment discount** | |
- | Bill Early Payment and Other discounts | + | |
- | + | ||
- | + | ||
- | + | ||
- | Some vendors allow for a discount to be taken for early payment on a bill. This **early payment discount** can be automatically calculated in Control through the proper use of Vendor payment methods. | + | |
- | + | ||
You can see the discount added to a bill by looking on the Items Tab of a bill. | You can see the discount added to a bill by looking on the Items Tab of a bill. | ||
- | + | {{: | |
- | + | ||
- | {{:: | + | |
- | + | ||
To use Bill Discounts, they must be enabled through Accounting Setup in Control. By clicking on Payment Terms, there will be a check box that reads "Allow discounts for early payment." | To use Bill Discounts, they must be enabled through Accounting Setup in Control. By clicking on Payment Terms, there will be a check box that reads "Allow discounts for early payment." | ||
+ | {{: | ||
+ | ===== Reports ===== | ||
- | {{:: | + | **A/P Aging Graph** |
- | + | ||
- | + | ||
- | + | ||
- | Reports | + | |
- | + | ||
- | + | ||
- | + | ||
- | A/P Aging Graph | + | |
- | + | ||
This is a graphical representation of Accounts Payable information in bar and pie graph form. Information in bar graph will be broken down by aging (current, 1-30 days, etc.) amount due, and information in pie graph will be broken down by vendor' | This is a graphical representation of Accounts Payable information in bar and pie graph form. Information in bar graph will be broken down by aging (current, 1-30 days, etc.) amount due, and information in pie graph will be broken down by vendor' | ||
+ | {{: | ||
- | |||
- | {{:: | ||
* Heading - Company information, | * Heading - Company information, | ||
* Report Name - Name of the report currently being viewed | * Report Name - Name of the report currently being viewed | ||
Line 269: | Line 160: | ||
* Pie Graph Information - Accounts Payable information broken down by vendor | * Pie Graph Information - Accounts Payable information broken down by vendor | ||
- | + | **A/P Aging Summary Report** | |
- | + | ||
- | A/P Aging Summary Report | + | |
- | + | ||
This shows a summary listing of AP aging items in a chosen date range. | This shows a summary listing of AP aging items in a chosen date range. | ||
+ | {{: | ||
- | |||
- | {{:: | ||
* Heading - Company information, | * Heading - Company information, | ||
* Report Name - Name of the report currently being viewed | * Report Name - Name of the report currently being viewed | ||
Line 293: | Line 179: | ||
* Total - Total of all open bills for this vendor | * Total - Total of all open bills for this vendor | ||
- | + | **A/P Aging Detail Report** | |
- | + | ||
- | A/P Aging Detail Report | + | |
- | + | ||
This is a detailed listing of the AP aging items grouped by vendor; this report is an option of the A/P Aging Summary. Each aging category will be totalled at the end of the report. | This is a detailed listing of the AP aging items grouped by vendor; this report is an option of the A/P Aging Summary. Each aging category will be totalled at the end of the report. | ||
+ | {{: | ||
- | |||
- | {{:: | ||
* Heading - Company information, | * Heading - Company information, | ||
* Report Name - Name of the report currently being viewed | * Report Name - Name of the report currently being viewed | ||
Line 317: | Line 198: | ||
* Total - Total of all open bills for this vendor | * Total - Total of all open bills for this vendor | ||
- | + | **Check Detail Listing** | |
- | + | ||
- | Check Detail Listing | + | |
- | + | ||
This gives a listing of all payments made in a chosen date range grouped by bank account. | This gives a listing of all payments made in a chosen date range grouped by bank account. | ||
+ | {{: | ||
- | |||
- | {{:: | ||
- | |||
- | |||
- | |||
- | c | ||
* Heading - Company information, | * Heading - Company information, | ||
* Report Name - Name of the report currently being viewed | * Report Name - Name of the report currently being viewed | ||
Line 343: | Line 215: | ||
* Total - Total of all payments made from all bank accounts | * Total - Total of all payments made from all bank accounts | ||
- | + | **Unreconciled Check Report** | |
- | + | ||
- | Unreconciled Check Report | + | |
- | + | ||
This is included as an option in the Check Detail Listing report. | This is included as an option in the Check Detail Listing report. | ||
- | + | **1099 Detail Report** | |
- | + | ||
- | 1099 Detail Report | + | |
- | + | ||
This will give a more detailed listing of 1099 vendor payment information for the chosen date range; it will also break down information by company division if you are using them. | This will give a more detailed listing of 1099 vendor payment information for the chosen date range; it will also break down information by company division if you are using them. | ||
+ | {{: | ||
- | |||
- | {{:: | ||
* Heading - Company information, | * Heading - Company information, | ||
* Report Name - Name of the report currently being viewed | * Report Name - Name of the report currently being viewed | ||
Line 368: | Line 231: | ||
* Vendor Detail - 1099 Information about bills submitted from each vendor; Payment Date, No. (check number), Description, | * Vendor Detail - 1099 Information about bills submitted from each vendor; Payment Date, No. (check number), Description, | ||
- | + | **Bill GL Detail Report** | |
- | + | ||
- | Bill GL Detail Report | + | |
- | + | ||
This report will show a detailed listing of bill GL information. | This report will show a detailed listing of bill GL information. | ||
+ | {{: | ||
- | |||
- | {{:: | ||
* Heading - Company information, | * Heading - Company information, | ||
* Report Name - Name of the report currently being viewed | * Report Name - Name of the report currently being viewed | ||
Line 390: | Line 248: | ||
* Credit - If the transaction was a credit, it will appear in this column | * Credit - If the transaction was a credit, it will appear in this column | ||
- | + | **Purchased Parts by Vendor Report** | |
- | + | ||
- | Purchased Parts by Vendor Report | + | |
- | + | ||
This report will show a detailed listing of parts purchased by vendor, grouped by vendor. | This report will show a detailed listing of parts purchased by vendor, grouped by vendor. | ||
+ | {{: | ||
- | |||
- | {{:: | ||
* Heading - Company information such as logo, address, phone, etc. | * Heading - Company information such as logo, address, phone, etc. | ||
* Report Name - Name of the report currently being viewed | * Report Name - Name of the report currently being viewed | ||
Line 411: | Line 264: | ||
* (Vendor Name) Totals - If more than one type of part was purchased from a vendor, this field will display the total of all parts purchased | * (Vendor Name) Totals - If more than one type of part was purchased from a vendor, this field will display the total of all parts purchased | ||
- | + | **Vendor Bill History Detail Report** | |
- | + | ||
- | Vendor Bill History Detail Report | + | |
- | + | ||
This will show a detailed listing of bills for vendors. | This will show a detailed listing of bills for vendors. | ||
+ | {{: | ||
- | |||
- | {{:: | ||
* Heading - Company information such as logo, address, phone, etc. | * Heading - Company information such as logo, address, phone, etc. | ||
* Report Name - Name of the report currently being viewed | * Report Name - Name of the report currently being viewed | ||
Line 427: | Line 275: | ||
* Vendor Detail - Bill information for each vendor; Bill Number, Description, | * Vendor Detail - Bill information for each vendor; Bill Number, Description, | ||
- | + | **Vendor Bill History Summary Report** | |
- | + | ||
- | Vendor Bill History Summary Report | + | |
- | + | ||
This report is included as an option with the Vendor Bill History Detail Report (see above). | This report is included as an option with the Vendor Bill History Detail Report (see above). | ||
- | + | **Vendor Contact Listing Report** | |
- | + | ||
- | Vendor Contact Listing Report | + | |
- | + | ||
This will give a list of vendor contact information. | This will give a list of vendor contact information. | ||
+ | {{: | ||
- | |||
- | {{:: | ||
* Heading - Company information such as logo, address, phone, etc. | * Heading - Company information such as logo, address, phone, etc. | ||
* Report Name - Name of report currently being viewed | * Report Name - Name of report currently being viewed | ||
Line 457: | Line 296: | ||
* Balance Outstanding - Balance of unpaid bills for this vendor | * Balance Outstanding - Balance of unpaid bills for this vendor | ||
+ | \\ | ||