CHAPTER
6
ACCOUNTS RECEIVABLE
Simply Accounting for Windows is a powerful tool for creating invoices, recording and keeping track of accounts receivable, and registering the payments received on account.
CHAPTER OBJECTIVES
The purpose of this chapter is to show how to: • Create, modify, and remove customers • Process sales orders
176 Simply Accounting for Windows, v. 8
COMPANY INFORMATION
Dixie Janitorial Services was established by Teflon Willie in 1989. After a rocky start, the business has been growing steadily. In the past he kept the General Ledger manually. He didn’t worry about keeping track of his Accounts
Receivable because he had few customers and it was easy to remember who had paid him. Recently there has been a significant increase in his business and Teflon is not sure any more who has, and who has not, paid. Teflon has approached you to analyze the Accounts Receivable to determine the amounts owed and invoices outstanding by customer. He then wants you to record the transactions using Simply Accounting for Windows.
HARMONIZED SALES TAX
Harmonized Sales Tax (HST) began on April 1, 1997 in New Brunswick, Nova Scotia, and Newfoundland. The HST replaced the Goods and Services Tax and provincial sales taxes in the participating provinces. The harmonized tax rate is 15% and applies only to taxable goods and services sold in or delivered to the participating provinces. HST does not apply to sales outside of the participating provinces, but GST does. Businesses keep only one set of sales tax records and complete only one return for each reporting period. They do not have to report and remit GST and HST separately. If a business in the participating provinces has taxable goods delivered from elsewhere in Canada, it will have to pay HST and input tax credits may apply.
DClick: the Simply Accounting icon from the Windows 95/98 desktop
Click: the Select an Existing Company option button
Click:
In the Open Company window:
Select: Dixie
Click: to accept the Session Date
FIGURE
6-1
Dixie’s Main Menu
Note the icons available in the Receivables column. The first, Customers, allows you to administer the files for the customers to whom you sell goods and ser-vices. The Sales, Orders & Quotes icon allows access to record sales of goods on credit or for cash. The last item, Receipts, allows you to record the payment of invoices as they fall due.
CREATING CUSTOMER RECORDS
Before you can record sales to customers, you have to create customer records. Customers can be created both using the Customers option or on the fly as you record sales invoices. If the company is a customer to which you expect to make regular sales you should use the Customers option to create complete files.
DClick:
178 Simply Accounting for Windows, v. 8
FIGURE
6-2
Customers window
The screen shows that five customers have been set up. There are two different ways of creating customers in this window. You can click the Create icon from the icon bar or select File from the Menu Bar, then click Create.
Click: the Create icon
FIGURE
6-3
Receivables Ledger Records notebook
The Receivables Ledger Records notebook allows you to create, delete, or modify customer records. You can use the E-Mail icon to send a note by e-mail to a customer, or even click the web site icon if you want to visit the customer’s web site. Note that there are six tabs at the top of the input pages to record information about the customer. These will be discussed in order.
The first customer you will record is Maragin Ltd.
Type: Maragin Ltd.
Press: Tab
Type: Kimkelina Mist in the Contact field
Press: Tab
Type: 4435 Gridlock Ave. in the Street Field
Press: Tab
180 Simply Accounting for Windows, v. 8
Press: Tab
Type: Nova Scotia in the Province field
Press: Tab
Type: B3J 4S2 in the Postal Code field
Press: Tab
Type: 506-555-3085 in the Phone field
Press: Tab
Type: 506-555-3086 in the Fax field
Press: Tab
If the customer has an e-mail address, you can enter it in the E-mail field. It is used in conjunction with the E-Mail icon at the top of the screen. (Note that the e-mail and web site addresses that follow are fictitious and will not work.)
Type: [email protected]
Press: Tab
Type: http://www.maragin.com
Press: Tab
FIGURE
6-4
Completed Customers Records window
If you have made a mistake you can correct it by clicking and highlighting the text in question and retyping the information. If you have any mistakes, correct them now.
Click: the Ship-to Address tab
You use the Ship-to Address to identify the contact person and address to whom you normally ship products for this customer. The address is displayed on sales invoices, orders, and quotes, and may be different from the one you specified on the Address page. Dixie Janitorial Services could have a contract for which they clean an office in Halifax, but have to send the bill to a central office in
Dartmouth to obtain payment. In this case the billing and cleaning addresses are the same.
Click: the Same as mailing address check box to activate it.
Click: the Options tab
182 Simply Accounting for Windows, v. 8
FIGURE
6-5
Options Page
The upper portion of this page is used to record the payment terms applied to this customer when Dixie Janitorial Service sends invoices. The lower part is used to define housekeeping functions you require to administer the invoices. No discount is offered to this customer. The net amount of the invoice is due within 30 days.
Click: the “% discount if paid within” box
Type: 0.00
Press: Tab twice
Type: 30 in the Net amount due within __ days field
Clear Transactions When Paid
The Clear Transactions When Paid option instructs the program to delete an invoice and the accompanying payment once it has been fully paid. The advan-tage of this is that the customer report does not become cluttered. You can choose to leave the paid invoices on the report and manually delete them when you want. The advantage of not clearing paid invoices is that you can adjust invoices where there have been errors by using the automatic features of Simply Accounting. In discussions with Teflon, it has been decided that the paid invoices should not be cleared automatically once paid.
Press: Tab
Include in HST Report
The Include in HST Report field is activated if you want to include the HST you paid in the HST Report. The field should already be active.
Press: Tab
Print Statements for This Customer
You can choose to send or not to send statements to a customer. The standard procedure is to send statements monthly to all customers.
Confirm: that the Print Statements for This Customer check box is active
Press: Tab
Forms for This Customer
You have the choice of either printing and mailing purchase orders to customers or sending them by e-mail.
Click: the list tool for the Forms for This Customer check box
Select: Print
Click: the Activity tab
184 Simply Accounting for Windows, v. 8
FIGURE
6-6
Activity page
The Year-to-Date Sales and Last Year’s Sales are displayed for information only. You can fill in these fields only when entering History. You can set a credit limit for any customer in the Credit Limit field. The program will alert you if the cus-tomer has exceeded the credit limit.
Click: Credit Limit field
Enter: 1000
Press: Tab
Click: the Memo tab
FIGURE
6-7
Memo page
You use this page to record any notes you want to keep about this customer, for example anything you want to discuss the next time your sales representative calls. The To-Do Date field is used to record the date you want the memo to appear in the To-Do Lists window. If you want the memo to appear immediately, you leave this field blank. The To-Do Lists window displays only the memo’s first 40 characters until you select to view the whole memo, so you would proba-bly summarize longer memos in the first 40 characters.
If you want the memo to appear in the To-Do Lists window, you have to activate the “Display this memo in the To-Do List” check box.
Click: the Import/Export tab
186 Simply Accounting for Windows, v. 8
FIGURE
6-8
Import/Export page
The “This customer has Simply Accounting and can import invoices and quotes” check box is activated when the customer has e-mail and uses Simply
Accounting. The customer can import your invoices and quotes electronically. You activate this check box to be able to export invoices and quotes to this cus-tomer.
The “This customer uses my item numbers on orders” check box can be activat-ed if this customer uses the same product codes as you.
If the customer uses product codes that are different from yours, you enter them in the lower portion of the screen along with your corresponding product code numbers for all items you sell to this customer. If you sell non-inventory items, you match the customer’s item number with your General Ledger revenue account.
If you do not want to make any further sales to a customer, you can make their file inactive by activating the Inactive Customer check box.
You have now finished creating the data records for this customer. Before you leave this window you must save the file.
Click:
Close: the Receivables Ledger notebook
FIGURE
6-9
Customers window
MODIFYING VENDOR RECORDS
Teflon has learned that he will be getting additional business from Computer Education Associates. After speaking to their bank manager he has decided to increase their credit limit to $1,500.
DClick: Computer Education Associates customer icon
Click: the Activity tab
Enter: $1500 in the Credit Limit box
Close: the Receivables Ledger
188 Simply Accounting for Windows, v. 8
REMOVING A CUSTOMER
After setting up Maragin as a new customer, Teflon has been informed by Kimkelina Mist that his prices are too high and that she will be using a different janitorial service.
DClick: the Maragin Ltd. customer icon
Click: The Remove the Current Customer icon from the toolbar
A confirmation dialog box will appear as displayed by Figure 6-10. Customers can only be removed when invoices and receipts relating to them have been cleared from the system.
FIGURE
6-10
Simply Accounting confirmation
Click:
Another dialog box will appear, enquiring if you want to clear the lookup data for this customer. You have not recorded any transactions to this file.
Click:
A third dialog box appears, telling you (what you already know) that there is no invoice lookup data to clear.
Click:
Close: the Receivables Ledger
Close: the Customers window
Click: Maintenance from the Menu Bar
Click: Clear Paid Customer Transactions ...
The Clear Paid Customer Transactions dialog box appears as shown in Figure 6-11.
FIGURE
6-11
Clear Paid Customer Transactions dialog box
This screen allows you to clear invoices that have been paid from the system. You can clear the paid invoices for all of your customers at once or select a sin-gle customer. You can also choose a date after which invoices will not be cleared.
Select: Bob’s Bistro
Click:
A Simply Accounting warning message appears reminding you to make a back-up of your files and to print all required reports. Backing back-up your data files is an important activity. Whenever the program suggests that you should perform a backup, you would be well advised to do so. In this simulation you will proceed without backing up the data files.
190 Simply Accounting for Windows, v. 8
A message will appear informing you that there are no invoices to clear.
Click:
ACCOUNTING FOR SALES
The General Ledger and Accounts Receivable have been set up as of the first day of the year. The current date is now January 17, 2000. When instructed, you should back up your data files, since you normally have information in them.
Click: Maintenance
Click: Change Session Date ...
You would normally back up your system to protect the data you have entered since your last backup. In this case, you don’t need to create a backup. When the warning message appears enquiring if you want to back up your data files:
Click:
Type: 01/17/00
Click:
Because you have entered a date that is more than one week into the future, you will see a date warning message. The date you have entered is correct, so you can proceed.
Click:
Close: the Checklists window
Close: the To-Do Lists window
Sales Orders
A Sales Order is a written request from a customer (it’s the customer’s purchase order) giving you permission to sell items or services to your customer. The first Sales Order you will record is to Maritime Industries for Office Cleaning
DClick:
The Sales Journal window will appear as displayed by Figure 6-12.
FIGURE
6-12
Sales Journal window
This window is divided into three parts. The top portion is used to record infor-mation about the customer, the location to which the goods are to be shipped, the quote number, the invoice number, and the current date. The middle section is used to record the goods ordered and the price, and the lower portion is used to record the sales taxes, freight, and terms. The terms are related to the customer. When you enter the customer name, the terms associated with the customer will appear.
Click: the list tool for the Transaction field (located under the icon bar)
Select: Sales Order
192 Simply Accounting for Windows, v. 8
Click: the Sold To list tool
Select: Maritime Industries Ltd.
You record a customer’s Purchase Order number in the Order/Quote No. field. The purchase order number sent by Maritime Industries is 00-1382.
Click: the Order/Quote No. field
Type: 00-1382
Press: Tab
The Ship Date is usually the date that the customer wants to receive the goods.
Type: 1/31/00
Press: Tab
You record in the Date field the date the sales order was placed. The current Session Date is displayed and does not require changing.
Press: Tab twice
The program has skipped over the Item and Ship fields because the Inventory module is not active. The Item field is used to record your inventory item code. The Order field is used to record the quantity of items ordered; it must be filled in.
Type: 1
Press: Tab
The order amount you recorded in the Order field will appear as a back order, because the goods have not been delivered yet. This field cannot be left blank.
Press: Tab
The Unit field is used to record the units in which the company makes sales. For example, if the sales order were for 100 dozen tent pegs, the unit would be recorded as “Dozen.” In this case you are selling 1 month of janitorial services, so the unit is “Month.”
Type: Month
The Description field is used to add a physical description of the goods sold.
Type: Janitorial Services
Press: Tab
In the Price field:
Type: 500
Press: Tab twice
When you added the price per month, the Amount field automatically displayed the extended value. The HST field is used to record the Harmonized Sales Tax. You access the HST Codes by pressing the Enter key.
Press: Enter
The Select HST window will appear as displayed by Figure 6-13.
FIGURE
6-13
Select HST window
194 Simply Accounting for Windows, v. 8
Select: “Code 3 HST @ 15.0%, not included”
The “HST @ 15.0%” at the bottom of the screen shows the extension of the HST rate times the dollar value of the sale. The cursor skips over the PST tax field because the HST option is active. Other provinces record the GST and PST sepa-rately, so the cursor would stop at the PST field and you would record the appro-priate rate.
The final step is to record the General Ledger account that will be charged with the sale.
Press: Enter
The Select Account window will appear as displayed by Figure 6-14.
FIGURE
6-14
Select Account window
You can scroll through all of the General Ledger accounts, then select the account appropriate for the journal entry. In this case you are contracting a sale to an industrial location, so account 4110 Industrial Jobs will be chosen.
Select: 4110 Industrial Jobs
FIGURE
6-15
Completed sales order
Once you are sure that your sales order is correct, you have to record it.
Click:
As soon as you record the sales order the screen clears in preparation for the next entry.
Close: the Sales Journal - Sales Order window
Change: the Session Date to 1/31/00
RECORDING SALES
Sales are recorded using the Sales, Orders & Quotes icon in the Receivables module.
196 Simply Accounting for Windows, v. 8
The first invoice is to Computer Education Associates for monthly cleaning services. This is a small, locally owned company that does not issue purchase orders, so Dixie Janitorial Services has not recorded a sales order. The
Transaction field at the top left defaults to “Invoice” whenever you start
the program.
Ensure: the Transaction field indicates “Invoice”
You have three payment options when recording an invoice: pay later, pay imme-diately by cash, or pay immeimme-diately by cheque. The next few invoices will be recorded using the Pay Later option.
Ensure: “Pay Later” is displayed in the Paid By box
Click: the list tool for the Sold To field
Select: Computer Education Associates
Invoices are prepared in sequential order, beginning with the number you
assigned on the Forms page of the Settings option on the Menu Bar. A number of invoices were recorded at the end of 1999. The invoice number displayed should be 6.
The date of the invoice is January 31, 2000.
Ensure: “1/31/00” is displayed in the Date field
You have the option of recording either the current Session Date or a prior date in the Date field. The payment terms are calculated from the date you record here. Remember, in this case you cannot record an invoice at a date in advance of the Session Date.
Click: the Ship field
Type: 1
Press: Tab
Dixie Janitorial Services bills Computer Education Associates on a monthly basis, so the unit description will be “Month.”
Type: Month
Press: Tab
Press: Tab
Type: 750
Press: Tab twice
Press: Enter to obtain a listing of the HST options
Select: “Code 3 - HST @ 15.0%, not included”
Press: Enter to see the accounts listing
Select: 4100 Commercial Jobs
The completed Sales Journal will appear as displayed in Figure 6-16.
FIGURE
6-16
198 Simply Accounting for Windows, v. 8
ARCHIVING AN ENTRY
Many of the invoices you send will be repeated frequently over the year.
Whenever you have a transaction for any one customer that will be repeated fre-quently, you can place it in an archive so you do not have to look up all the details each time.
Click:
The Store Recurring Transaction dialog box will appear as displayed by Figure 6-17.
FIGURE
6-17
Store Recurring Transaction dialog box
Simply Accounting for Windows moves the recurring transactions to the top of the list on the basis of the frequency indicated and the current Session Date. Invoicing to Computer Education Associates is sent monthly, so the frequency should be set to “Monthly.”
Click: the list tool for the Frequency field
Select: Monthly
Click:
DISPLAY SALES JOURNAL ENTRY
When completing an entry in any of the modules, it is advisable to review the entry you have created before it is posted.
Click: Report from the Menu Bar
The Sales Journal entry is displayed in General Journal format as in Figure 6-18.
FIGURE
6-18
Sales Journal Entry window
The entry indicates a credit to account 2370 HST Charged on Sales. This is a liability account, so it should be a credit; 4100 Commercial Jobs is a revenue account, so it should be a credit; and the Accounts Receivable represents an increase in assets, so it should be a debit.
Close: the Sales Journal Entry window
Click:
Once you post the transaction the screen clears in preparation for the next invoice.
CHANGING CUSTOMER CREDIT LIMITS
Record: the following invoice:
31 January The company billed the Office Furniture Store for the monthly janitorial services, $750 plus HST. Allocate the revenue to Account 4100.
Display: the Sales Journal Entry to ensure it is correct
Post: the Office Furniture Store invoice
200 Simply Accounting for Windows, v. 8
history, it is preferable to know about the problems when the sales order is received, rather than after the goods or services have been delivered.
Click:
Close: the Sales Journal
EXERCISES
DIXIE JANITORIAL SERVICES
1. Create the following new customers for Dixie: Reno’s Rewards E. Presley 35 Harmony Road Halifax Nova Scotia V3Y 3L7 (506) 555-4568 (506) 555-7896 [email protected]
Ship-to address is the same Terms: 30 days
Include in HST report
Credit Limit: $1,500
(506) 555-7852 (506) 555-4587 [email protected]
Ship-to address is the same Terms: 30 days
Include in HST report
Credit Limit: $2,000
2. Record the following sales for Dixie: 4 January Sales Invoice 8
Reba’s Routines
Weekly cleaning services $200, HST $30, total invoice $230. Set this up as a recurring invoice, weekly. Allocate revenue to account 4100.
8 January Sales Invoice 9 Julie Juno Inc.
Emergency cleaning $500, HST $75, total invoice $575. Allocate revenue to account 4100.
11 January Sales Invoice 10 Reba’s Routines
Cleaning services $200, HST $30, total invoice $230. Recall the recurring invoice.
3. Create a sales order for Reno’s Rewards. The sales order is created on January 5. The service is to start January 15. Cleaning services will be pro-vided for one day each week starting on the 15th of this month. A day’s work for the crew will be billed at $200 a day. The sales order number RR 000107, is a firm commitment for a year. Set it up as 52 days, one day a week. The sales order of $10,400 with $1,560 HST totals $11,960. Allocate revenue to account 4100.
