Contents 

What's new in Free Accounting
Free Accounting Help
Introduction
Installation
Interface Overview
Lists
Companies List
Chart of Accounts
Master Transaction Ledger
Items List
Inventory Control Journal
Sales Tax Code List
Units of Measure List
Customer Classes List
Terms List
Tax Jurisdictions List
Ship Via List
Countries List
State/Provinces List
Customers List
Vendors List
Payees List
Employees List
Contacts List
Company
Companies List
Chart of Accounts
Master Transaction Ledger
Journal Entries List
Contacts List
Customers List
Vendors List
Payees List
Employees List
Items List
Inventory Control Journal
Purchase Order List
PO Receipt List
Return PO List
Return PO Receipt List
Sales Orders List
Invoice List
Return SO List
Credit Memo List
Post Entries
Record Opening Balance
Bank and Checks
Check Register
Bank Reconciliation
Deposit Funds
Print Checks
Receive Payments
Write Check
Vendors
Vendors List
Purchase Order List
PO Receipt List
Payments and Charges History
A/P Aging Summary
Pay Bills (All-in-One, Wizard)
Physical Adjustment
Create Purchase Order
Create PO Receipt
Create Return PO
Create Return PO Receipt
Create Bill
Customers
Customers List
Sales Orders List
Invoice List
Receive Payments
Payments and Charges History
A/R Aging Summary
Payments and Charges Reconciliation
Create Sales Order
Create Invoice
Create Return SO
Create Credit Memo
Reports
Vendors and Payables
Customers and Receivables
Sales
Banking
Payees
Company and Financial
Lists
Accountant and Taxes
Documents
Options
Free Accounting Tutorial
Introduction
Conception
Get Started
Lesson 1. Company Information
Lesson 2. Create a Vendor
Lesson 3. Create an Item
Lesson 4. Purchase an Item
Lesson 5. Create Purchase Order Receipt
Lesson 6. Make Payment to the Vendor
Lesson 7. Vendor Pay Bills
Lesson 8. Create a Customer
Lesson 9. Create a Sales Order
Lesson 10. Create an Invoice
Lesson 11. Receive Payment form the Customer
Lesson 12. Reconcile Payment with Charge
Lesson 13. Customer SO Return
Lesson 14. Vendor PO Return
Lesson 15. Create Return PO Receipt
Lesson 16. View Reports
Lesson 17. Bank Reconciliation
Lesson 18. Trial Balance

Free Accounting Software Help File Version 1.0.0.6

Prev Page Next Page
Payments and Charges Reconciliation
All-in-One

The All-in-One window allows the user to adjust the existing Customers' charges with the existing payments.
  1. To make adjustments select Customers / Payments and Charges Reconciliation / All-in-One from the Main Menu.
  2. Select the Customer from the drop-down list.
  3. Select the charge you want to adjust. Make all the necessary changes.
  4. Select the payment that is to be adjusted. Change the figures if it is needed according to the selected charge.
  5. Press the Reconcile button at the bottom.

The Payments and Charges Reconciliation table is divided into two parts: Customer's Charges and Customer's Payments.

The Customer's Charges grid:
  • Pay box is checked to select the charge we want to adjust.
  • Customer - The unique Customer id.
  • Invoice# - The number of the invoice.
  • SO# - The number of the Sales Order.
  • Date - The date the charge was made.
  • Transaction - The description of the transaction.
  • Charges$ - The amount of the charge.
  • Adjust$ - The amount that is to be adjusted. When the user checks the «Pay» check box on the current line the column Adjust $ will be equal to Open Amount$ by default. The user has the possibility to change the amount in order to specify how much of the Open amount will be adjusted. The column Adjust$ should not be less than 0 or more than Open Amount$.
  • Term - The payment terms set in the Customer records.
  • Discount - The amount which we can set to subtract from the Customer's charge.
  • Discount Reason - The reason why we give the discount to the Customer. If the user puts a value in the Discount column then he must also put some note in the «Discount Reason». When the grid is refreshed the so called «Adjust$» and «Discount» columns will contain 0. The «Discount Reason» will be blank.
  • Fin Chrg - Finance Charge.
  • Total$ - The total amount of the charge.
  • Open Amoun$ - The open amount of the charge.

Spread Selected Payment box - This box is checked when it is necessary to adjust the Master Customer's payments against Child Customers' charges. To make this we need to transfer funds from Master Customer to Child Customer1 and to Child Customer2 (there can be more Child Customers) through 'Equity/Net worth' account. So in this case it will be 2 pairs of journal entries in MTL:

Charge for Master Customer  -  Increasing Master Customer's Account Receivable
Payment for Child Customer1  -  Decreasing Child Customer1's Account Receivable
Charge for Master Customer  -  Increasing Master Customer's Account Receivable
Payment for Child Customer2  -  Decreasing Child Customer2's Account Receivable

The Customer's Payments grid:
  • Select - It should be checked when you want to select payment for adjustment.
  • Date - The date when the payment was made.
  • Source Number - The check number.
  • Transaction - The description of the transaction.
  • Payment$ - The amount of the check.
  • Adjust Now - The amount of the payment that is to be adjusted. The user has the ability to change this amount to specify the amount that will be adjusted. The column should not be less than 0 or more than Open Amount.
  • Open Amount - The total amount that can be adjusted.

On the right of the screen there are fields that reflect the changes made in the tables:
Selected Payments, (+) Discount Allowed, (-) Selected Charges, (-) Fin Chrg and Balance.
Balance  =  Selected Payments + Discount Allowed - Selected Charges or Balance  =  Selected Payments - Selected Charges - Fin Chrg

At the bottom of the page you can select an account which will be affected when a discount is given to the Customer.

See also:
Customers

   
Published by Systems Online/SCT