Manually Allocating Cash

Before allocation, a customer and item should must be entered:

Entering a Customer and Item to Spreadsheet

Right click in the allocate_to range, select Allocate and the following screen will be displayed:

Manual Allocation Image

This lists open sales items Clicking on an item allocates the outstanding amount.

The Delete key will remove the allocation The allocated and unallocate amounts are shown at the top of the screen. If you over-allocate, then the unallocated amount will be red You can remove the allocations selected by clicking Remove Allocations Clicking on a column header will reorder the data by that column (click twice to reverse that order) You can select which items are displayed on the list (see Options). Clicking OK will return the allocations to the spreadsheet.

Returning Allocations to Spreadsheet