.
Debtors Reconciliation in MYOB
 
Debtors Reconciliation in MYOB
 
indent You should reconcile your accounts receivables after you have entered all the sales invoices, customer payments and credit notes/adjustments for the period.

indent The Receivables Reconciliation [Summary] is in the form of an Ageing Analysis. In MYOB the Debtors Reconciliation and Ageing Analysis are carried out at the same time.
               
    Business Name    
           
    Receivables Reconciliation [Summary]  
    as at 31 October 2007  
             
  Name Total Due 0 - 30 31 - 60 61 - 90 90+  
  A-Z Stationery Supplies $1,334.00 $505.75 $228.25 $600.00 $0.00  
  James Cameron $324.00 $0.00 $0.00 $324.00 $0.00  
Chelsea Mosset ($72.50) $0.00 ($17.50) ($55.00) $0.00  
Footloose Dance Studio $1,243.00 $1,243.00 $0.00 $0.00 $0.00  
Island Way Motel $1,879.25 ($92.50) $2,029.50 ($57.75) $0.00  
Leisure Landscape Nursery $699.00 $301.00 $398.00 $0.00 $0.00  
My Town Reality $1,849.25 $719.00 $468.75 $175.50 $486.00  
The Motor Company $72,685.35 $70,000.00 $1,685.35 $0.00 $1,000.00  
             
Total: $79,941.35 $72,676.25 $4,792.35 $986.75 $1,486.00  
Ageing Percent:   $0.91 $0.06 $0.01 $0.02  
             
             
Receivables Account: $79,941.35          
Out of Balance Amount: $0.00          
             
             
  • From the Reports menu choose Index to Reports

  • Select the Sales tab to display the sales reports.

  • Select the Reconciliation Summary report so that it is highlighted

  • Click the Display buttom. The Report Customisation window appears

  • Ensure the Aging Method option is set to Calculate Days Overdue Using Invoice Terms.

  • In the Receivables As Of field, type 31/10/07 then click display

  • If the total of the customer cards don't agree with Debtors (Receivables) on the Balance Sheet an out of balance amount will be displayed.

  • Common errors include:

    • Invoicing a cash sale through debtors and paying through receive money in the Banking command centre.

    • Using the wrong allocation account for a sale. Entering a transaction directly to Trade Debtors instead of the income account.

    • Entering a Journal Entry that is allocated to the linked Receivables Account but does not effect the subsidiary account.

    • A customer payment has been dated prior to the customer invoice.

    • Incorrect dates on invoices (e.g. dated after the reconciliation date)

  • Correct "Out of Balance" amount

    • Change the date for the Reconciliation Summary Report until the " out of balance" is zero.

    • Highlight the date on the Report and add one day (+ Tab) or deduct one day (- Tab) and redisplay after each change.

    • Once you have found the date of the 'out of balance amount' click Close

    • Locate the incorrect transaction.

    • From the Sales Command Panel , click on Find Transactions and select Account from the drop-down list. The Find Transactions window appears.

    • In the Search By field, ensure Account is selected and click on the drop-down arrow in the next field.

    • From the drop-down list select 1-1200 Trade Debtors. Click Use Account

    • In the Dated From and To fields, type in the date of the incorrect transaction and press TAB.

    • A shortcut to find transaction is "Ctrl Y". Search By select Account and select 1-1200 Trade Debtors from the drop-down list. Type in the relevant date and press TAB.

    • All transactions posted to the Trade Debtors account on the particular date are displayed. View each transaction until you find the incorrect one. Click the zoom arrow.

    • Cash transactions are "yellow" and debtors transactions are "blue".

    • From the Edit menu, choose Reverse ... Transaction, record, and then re-enter the transaction correctly.

    • Check the Receivables Reconciliation Summary again to make sure the " out of balance" is zero.