The first thing to do it to pay all the water bills to the water company.
Then you must type the payments into quickbooks.
The next thing to do is to go to the water company web site and double check which water bills have been paid.
- Sort already paid water bills in alphabetical order by property address
- Copy the water bills on “clean-on-both-sides” paper
- Go to water payment history web site http://waterpayments.columbus.gov/
- Type in account number from water bill without dash
- Check to see if it is the correct address and owner
- To print water payment history
- right click mouse to bring up print menu & select print preview
- change shrink to fit to 80%
- click page 2 arrow at the bottom of the page to check no payment history has gone on to page 2
- click printer icon at the top right of the page.
- check radio box to print only 1 page
- select correct printer
- click preferences and change color to black and white to save toner
- insert recycled paper with one-side-clean into manual feed of printer with clean side up to conserve trees
- select print
- click the back button and repeat for all water bills you are doing today
Create invoices for water bills for tenants
- Go to Customer center
- Scroll down and click on customer to see all transactions
- Look in the memo section of the transactions to see the previous invoices. Double check these with the water billing history printouts to make sure no invoices were missed.
- Double click on the most recent water invoice to open it up.
- Go to the top of the screen to click Edit
- Scroll down and click Duplicate Invoice
- Change the following fields:
- Date: Use todays date
- Amount: Type in the new amount they owe from the water letter that you just printed out
- Description: Input the dates of usage and the amounts in the following format: Water 7/8/14-10/9/14 ($240.06-$150=$90.06) This imformation is very important for bookkeeping
- Copy the description into the bottom memo field. This is important so it shows up on the transaction list.
- Click Save and Close
- Write billed and invoiced and the date on the original water bill
- Set letter aside to be mailed
- Put original water bill in letter tray to be filed
- Repeat for all water bills
The next step is to create water invoices to mail to the tenants
- Company
- Prepare letters w envelopes
- Customer letters
- Unmark all
- Check the names of those tenants you want to send the bills to
- Tic letter templates available for customers jobs
- screen says “Enter Name and Title” leave this blank and click next
- Computer says “Creating letters please wait”
- A Word icon pops up at the bottom of the screen. Click on this to bring up the merged letters you just created
- Scroll down and check letters for any errors
- Put previously copied water bills in order of letters in Word document
- Print letters on the other side of the previously copied water bills
- Take out the letters that have a credit balance and set aside for later
- Create invoices for tenants in QB before you mail the letters