A tough task in any accounting package is making it easy to
allocate receipts since:
You need to make sure that you can't allocate more than you
received, and that you don't over-pay or under-pay any individual invoice.
Here's how I solved these problems using color to alert the user as
to errors. (If this looks too complicated for your needs, look at my
simple, inexpensive billing and receipts
First, let's start with an overview of the screen:
A note about taxes
This client had an unusual situation since some invoices are
taxable and some aren't, even for the same customer.
Invoice 14 IS taxable (note that $243.80 is in the Taxable
Invoice 15 is NOT taxable (note that $230.00 is in the
When you click the "Taxable" box in the Allocations
section of the screen, the system automatically divides the payment into
"principal" and "tax" depending on the tax rate for that
Now let's allocate part of this receipt to pay Invoice 14.
To correct the problem, the user just has to click the
"Taxable" box and the system will calculate which part is
"Tax" and which part is for "Principal" (it looks up the tax
rate on the invoice).
Now we'll make an allocation to the second invoice, Invoice 15.
They got a little carried away and allocated $230.00 even though
they only had $156.20 left. Note that the "Balance" box is still
To correct the problem, the user now allocates only what's left
to Invoice 15:
Done properly, this receipt can be allocated to these two
invoice with just a few keystrokes:
Type "14" in the Invoice drop-down-list,
Tab to the Amount box and type in "243.80"
Tab to the Taxable check box and tap the space bar to select
the taxable flag (the system automatically calculates the tax breakdown)
Tab to get to the next row then type "15"
Tab then type "156.20" and you're done!
There shouldn't be any red to the right in the invoice section
(which would indicate a tax error) and the Balance box should be white (and a
balance of 0).
This is part of a complete order entry, invoicing and accounts receivable
package I wrote.
Peck Tech Designs - consultants providing creative custom software development,
integration, Internet web site programming, database design, and application and data
conversion to clients in Connecticut and throughout the USA.
Copyright © Rachel Peck 2003 - all rights reserved
Terms and Conditions of use