Monthly Statements

Both Penny and Darin will get a statement at the end of the month and we pay them online (or receive money from Darin) accordingly.

Akaroa Booking Office Statement

1. Ensure all Transactions for the month are entered and posted.

Akaroa Booking Office – DARIN00 is a debtor.
Check that all Debtor Invoices to DARIN00 are posted.
The Bank Reconciliation for the month needs to be complete.

2. Make a list of all rides – with total

Account enquiry – (ctrl-e) 1000-AK

Movements Tab

Month eg November to November

If there are errors in the list (red), highlight only the correct ones.

Print (ctrl-p)

Top Box – ticked

Bottom Box ticked if there were errors and we are printing highlighted ones only.

Make a pdf file in landscape and save it in the usual pdf folder KTHT/accounts/pdfs
Call it

Sales-Akaroa-2010-10.pdf (10 being the month, eg October)

Note total of the right hand Net amount, add 15% for GST -and calculate 15% of that.

3. Credit Note

Make a Debtors Credit note for the 15%

This is a Debtor Invoice to the Commission account, with a minus (-) amount.

Post it

4. Statement

Go to Names (Ctrl-2) find DARIN00 (Akaroa Booking Office), Right click – Print Statement

Use the KT Period Aging form

Use Print to make pdfs of statement: eg darin-statement-2010-10.pdf

Variation if we owe him money

If we owe him money this will show as a minus (-) amount on the statement.

Pay online

This will need to be entered into the MoneyWorks system using

Command | Adjustment | Return Cheque to Debtor

or

He owes us Money – this is the balance on the Statement
He sends us a cheque.
We bank the cheque
In MoneyWorks, this is a normal Cash Receipt

DARIN00 is the Debtor Code – the amount Outstanding on the invoice should match the amount of the cheque.

7. Send email and attachments.

Subject line: Riding Commission – October 2010

Attach pdfs:

sales-akaroa-2010-10.pdf
darin-statement-2010-10.pdf

Body of email:

Hi Darin

Attached is the list of rides we did and a statement for October.

On this occasion we owe you money. We have paid the difference into your account.

OR

On this occasion you owe us money, please deposit into our account.

Regards,

 

 

 

 

 

 

Penny Sparrow Statement

Penny is a Creditor

[[[ under construction ]]]]

One thought on “Monthly Statements”

  1. Talking to simon at cognito.

    Invoices for rides are right.

    Getting the commission total is right

    At end of month

    * Make manual statement using Payment history in Names View.

    * Raise Creditor invoice for Commission we owe him (Same date for these two entries)

    * Process rides as Cash receipt

    DON’T enter the cheques in MoneyWorks at all.

    * Use the two entries to reconcile the diffence which will show on the bank statement.

Leave a Reply