home page
main index    Support   FAQ

ask a question

Return to main index
 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
 
Accounting Questions

These pages provide suggested guidelines for discussion on a variety of accounting topics. Please read the following important information and then review the menu below.

Please Note: From a support point of view it is our goal to provide a reasonable level of resources to assist everyone get to grips with the accounting fundamentals but there is a line we must draw to preserve the boundary between teaching everyday accounting tasks and taking over your accountant's position.

To preserve the relationship between you and your professional accountant we have established a boundary that we cannot help you in unless your accountant is involved.

Such boundaries include:

  • Setting up your General Ledger
  • Converting to GST on an Invoice Basis
  • Managing an overseas currency account
  • Processing Accrual Journal Entries
  • Auditing your Accounts unless for a security reason.

In addition to this mandate we also recognize that if you are processing a complex transaction you should be in consultation with your accountant as their advice is invaluable.

Disclaimer
Any accounting advice, information derived, or procedure suggested should always be confirmed by your accountant. SoEasyAccounting.com Ltd nor any of its staff or associates accept any responsibility for inaccuracies in the information provided at any time and any advice should be used as a guideline only for discussion with an appropriate accounting professional.

 
Menu (please select a menu item)
GST
  GST on an Invoice Basis
  GST on a Payments Basis
  Non GST Entities
  Non Tax Entities
 
Debtors
  How to charge interest
  First invoice number
  Can I delete an invoice and re-use the number?
  Can I store manual invoice numbers against an invoice?
   
Stock
  I sold an Asset to one of our client's, how should I process the transaction?
  We have taken an item from stock for business use. How do we recognise this?
   
Creditors
  I paid a creditor incorrectly, how can I reverse the entry?
  How do I record Wages owed to staff in the Creditor's Module?
  How do I record the amounts owed to the IRD?
  How do I record the amounts of holiday pay owed to staff?
   
End Of Year
  I haven't finished Invoicing for March 2007. Should I roll over?
  My Trial Balance is out. What should I do?
  I have finished my Invoicing and Creditors but have not yet reconciled my cash book
  I have rolled over and now my opening balance in my Main Bank is wrong
  My reconciliation shows that I have an unpresented cheque value greater than I should have
  How can I print reports from a previous financial year?
   
Company Assets
  A staff member bought a company vehicle from us. How should I process the transaction?
   
GST
GST on a Payments Basis
  Payments basis GST returns are derived through one area only
  • The Cash Book

When a payment or receipt is made in the Cash Book, the gst component is captured and provided on the GST Reports. This is a relatively simple GST reporting system as most people need only reconcile their cash book with their bank statement and achieve a relatively accurate result.

   

GST on an Invoice Basis

  Invoice basis GST returns require a more sophisticated approach to GST capture as the GST is calculated on the specific date that transaction are entered into four specific ledgers:
  • Debtors ledger
  • Creditors ledger
  • Cash Book
  • General Ledger Entries

Transaction in these four areas accumulate into the Accrual General Ledger and provide the reporting capabilities for reporting GST on and Invoice Basis.
 

  To provide accurate reporting your accounts must be kept in a methodical manner and  regularly reconciled.

Your Administration Staff should attend one of our certified courses on the Accrual System to gain a grounding in the subject. (Select here for details and booking)

If you are on GST on an Invoice Basis it is very important that you get your accountant involved in helping you set up your system appropriately as our general support staff are not qualified to assist you in this manner. We do have Accountants who can brief your accountant on the subject and there are accountant's web pages available for them to gain information from. Any assistance to set up the Accrual General Ledger is charged for separately.

 

Non GST Entities
  If you are not charging GST to your clients then SoEasyAccounting can be set up to accommodate this. Simply go into the Cash Book Main Menu - Set up - GST Info.

By setting your system as NOT REGISTERED for GST, gst will not be calculated on any transactions entered into the system.

Non Tax Entities

  If you are a Non Tax Entity select the Non GST Entity setting above.

All Tax references are eliminated from documents such as Quotations, Invoices and Statements.

Debtors

How to charge interest

  If you are charging interest on overdue accounts it is important to recognise that Interest is NON GST and it is not a sale so creating an Invoice for the Interest is incorrect.

Recommended Procedure

  1. Find the client in the database
     
  2. Select the Receipts Tab
     
  3. Make sure you are on the client's account details
     
  4. Make a journal entry

e.g.

Increase the amount they owe Yes
Date Date of interest charge
Amount Amount of interest
GSt No
Details Interest .05% * $230

and select OK

This charge will now appear on their next statement

 

   
First invoice number
  The first Invoice number can be set when you create your first quotation or Invoice. You will receive a prompt when you click on "Add an Invoice".

You can also set this number, if no invoices/Quotes/Credit Notes have been created yet by going into Platform - Set up - Invoices - and select the button '1st Invoice Number'.

After this number is set, all numbering of Quotes, Invoices, and Credit Notes will be sequential.

Can I delete an invoice and re-use the number?
  Yes if you simply want to send the Invoice to the same client.
Do not delete the Invoice, instead remove the items. Next time you invoice the client make sure you change the header details by selecting the header with your mouse

Yes if you have not deleted the invoice (See 'Setting a different client for an Invoice')

No is all other circumstances. We keep all Invoice numbers as an audit history. There are Audit Trails so that all charge events can be traced.

Can I store manual invoice numbers against an invoice?
  Yes. Go to Platform - Set up - Invoices - and select the button "Optional Number' and set up your options.

When creating an Invoice, enter your manual Invoice number in the field identified as the hand written invoice.

SoEasyAccounting will still issue a unique Invoice number but the written Invoice number will also appear on the Invoice notes and on the client's statement.

 
Stock
I sold an Asset to one of our client's, how should I process the transaction?
  We had a compressor for in-house use.

We then sold it to a client

The situation is that you would have paid for the compressor through the Cash Book (or Creditor's ledger) and assigned it against a account code i.e. A-ASSETS

Solution

1   Create a GST invoice for the client for the compressor.
     Add the item as a NSI (Non Stock Item)

2   Close the Bill

3   Receive the payment when money received

4   Go to the Cash Book - Cash Account

5   Add the following transaction through the Cash-Book, Cash Account, to remove the asset value from the asset register

 

Date Date the sale took place
Details Compressor Sale to client
GST N in all cases
Amount The net amount (before GST) the item sold for
Receipt/Payment Receipt
Method Cash
Account A-ASALE
 
add account if not available
Name Asset Sales
Abbrev ASALE
Type Asset
GST N
Classification Long Term Assets

 

6  Add the following transaction through the Cash-Book, Cash Account, to transfer the asset to the Purchases account

Date Date the sale took place
Details Compressor Sale to client
GST N in all cases
Amount The net amount (before GST) the item sold for
Receipt/Payment Payment
Method Cash
Account A-TM-SLS (or the division you used when selling the item on the invoice)

This should now show your sales reduce because the original invoice increased sales and would be incorrect to leave it in this position, and you Long Term Assets reduce to reflect the sale of the item.

The transaction at step 5 would have increased the balance of the Cash on Hand account and then at step 6, it would have returned to the original value it was before these transactions were entered effectively creating a Journal Entry.

At the end of the year, when you print off reports for your accountants, the Asset report will show them the details of the asset sale and they will be able to process it accordingly.

 
We have taken an item from stock for business use. How do we recognise this?
  It is a common practice for companies to take items from stock for their own use.
  1. Invoice yourselves for the item/s at nothing less than the normal cost price. This is a normal GST transaction.
     
  2. Receive a payment on the invoice or if closed, through the normal receipting process, for the full amount.
    Payment in Cash to the Cash on Hand account.
     
  3. Close the Invoice if not already closed
    This will identify where the stock item went and deduct the item/s from stock on hand. It will also place the cash on hand account in credit which must be resolved.
     
  4. Cash on Hand Transactions required
    These transactions will depend upon the use that the items are being put to in your business:

    Consumables (e.g. Stationery)

    Long Term Asset (e.g. Car purchase)
     
Record the correct account code
Date Date of transaction
Details Detail of item taken for co. use
GST Y (always)
Amount The invoice value including GST
Receipt/Payment Payment
Method Cash
Consumables Account would be A- STAT or the appropriate expense account
Long Term Asset A-ASSET or the appropriate asset purchase account
 
Bank Involved Cash on Hand

This should now show your expenses/assets increase to accommodate for the acquisition, and your cash account reduce back to zero.

   
Creditors
I paid a creditor incorrectly, how can I reverse the entry?
  Understanding what happened first can help

If you have actually paid the money to the creditor then there is nothing you need to do other than resolve the issue with the creditor either by a refund or just being in credit.

If you have not actually paid the amount then:

  The Payment has
Creditors Module
  • Reduced the amount owed to the Creditor
Cash Book
  • Reduced the Bank
  • Reduced the Accounts Payable Account
  • GST = increased the claim for GST
Accrual General ledger
  • Reduced the Bank
  • Reduced the Accounts Payable Account
  • GST = No effect
Solution The process for reversing this transaction is quite complicated so we made the process easier in version 2007.29. If you do not nave this version or greater, please upgrade.

 

For the Creditor that you have paid incorrectly

1. Make a new payment as follows:

  • In the Creditors Module, select 'make a payment' as follows
  • Amount = negative value of original payment e.g. -$2000.00
  • Method = Cash
  • Statement details = "Reversal of incorrect payment"
  • Date = same as the original incorrect payment

2. The Cash Book will now have two entries.
No further action need be taken with them but be aware of them when performing your reconciliation of the bank accounts.

   
How do I record Wages owed to staff in the Creditor's Module?
  1. Add each staff member into the database and set them as a supplier in the Group called STAFF

2. You could set up an account code for each staff member in the Cash Book, Accounts section or just one global account for WAGES such as A-WAGES.

example of an account created for each staff member

Divison Choose the one appropriate to the worker e.g. "Administration"
Account Name Peter Blake Wages
Abbreviation WAGPB
Type Expense
GST NO
Classification WAGES

3. In the Creditors Module, for each staff member, set the standard account code to either the individual staff's account abbreviation (e.g. A-WAGPB) or if using one global account the appropriate account (e.g. A-WAGES)

4. Now load in the amounts due into the Creditors Module as if the Staff member was a creditor. IMPORTANT Make sure GST is set to NO for each entry. You will be prompted about the GST issue if you make a mistake.

5. When paying the staff member, be sure to pay them through the creditors module

 

How do I record the amounts owed to the IRD?
 
GST GST is automatically calculated by SoEasyAccounting so there is no requirement to enter the amount other than the year's opening balance. This is a Cash Book Set up question and should be done when first setting up.
FBT FBT is an individual bill so it must be treated just like any other creditor.

Suggestions
 

  • Make a specific Supplier in the Database called IRD FBT
     
  • The Account code is A-FBT and may require setting up.
     
  • GST is applicable
PAYE PAYE is calculated at the same time as calculating the WAGES as per this topic

PAYE is an individual bill so must be treated just like any other creditor.

Suggestions

  • Make a specific Supplier in the Database called IRD PAYE
     
  • The account code is A-PAYE
     
  • GST is NOT applicable
How do I record the holiday pay amounts owed for staff?
  Holiday Pay is handled in exactly the same as Wages answered above.

Some improvement could be to add specific accounts in the Cash Book, Accounts section.

e.g.

Divison Choose the division the staff member is associated with e.g. "Administration"
Account Name Peter Blake Holiday Pay
Abbreviation WAGHPPB
Type Expense
GST NO
Classification WAGES

Then load the amount due in the Creditors module as per the Wages section above.
If loaded in this manner make sure that when you pay the staff member their holiday pay that you pay it through the Creditors Module and do not just enter it into Cash Book.

   
   
End Of Year
 
I haven't finished Invoicing for March 2007. Should I roll over?
  No. You should make sure that all your Invoicing is done, Invoices are closed, and a statement run is performed.

You will still be able to Invoice new jobs for April but you will not be able to:

  • Close new financial year invoices
  • Add new financial year creditors
  • Receive or pay new financial year transactions

 until the rollover is done.

 

My Trial Balance is out. What should I do?
  If it is a few cents out then this is due to GST rounding and is acceptable.

If it is more than a few cents perform the following:

  1. Go to The Cash Book Main Menu and select the Set up button
     
  2. Select Test Data
     
  3. Run the Check of System Stage 1 procedure
     
  4. Once the procedure has checked all transactions you will be asked
    "Do you want me to Recalculate Account Values?"
    Select Yes
     
  5. An analysis report will be offered. If any issues were found please print off the report
     
  6. Reprint the Trial Balance report and see if it now balances

If the Trial Balance still does not balance please select this link contact us.
A consultant will be in touch to help you resolve the problem.

 

I have finished my Invoicing and Creditors but I have not reconciled my Cash Book
  If it is important to roll over and you can't quickly reconcile then
  1. Take a backup
     
  2. Print off the Debtors Aged Report
     
  3. Print off the Creditors Report
     
  4. Roll over your accounts

You will be able to re open your previous year's cash book, reconcile the accounts, and produce the EOY Reports by:

  1. Go to Cash Book Main Menu
     
  2. Select 'Set up'
     
  3. Select 'Years'
     
  4. 'View a Different Financial Year'
     
  5. When asked to type in a password, use the one displayed
     
  6. You can now edit the Cash Book

When complete, simply exit SoEasyAccounting. When you return you will be in the current year's transactions.

You can go into previous years Cash Book transactions at any time.

You will not be able to change any entries inside Platform whilst you are in a previous financial year.

Important!

A) The old year will no doubt create new closing balances that will need to be entered into the new year's (current year) opening balances.
 
procedure Cash Book -Set up - Open balances - Select this button to load balances

B) If following this technique do not roll over the previous years accounts again.
 

I have rolled over and now my opening balance in my Main Bank is wrong
 
  • Open SoEasy and go into Cash Book
     
  • Now select the close X button on the top right which will close the program down.
    Note: This is not the way to normally close the program.
     
  • Go back into SoEasy and the values should be correct

When you crash out of SoEasy in this manner and go back in, the Bank Account values are all re-calculated. The EOY process can sometimes store the wrong opening balance values during the procedure and this technique resolves the issue.
We are looking into this.

My reconciliation shows that I have an unpresented cheque value greater than I should have
  In versions prior to Ver Ref 2007.32 released on the 14/4/2007 you could set an ap payment from the Creditors module as being unpresented and the AI unit did not trap the issue and let you know.

The solution to this problem is:

1. Download the latest version so that it does not happen again

2. Open the Cash Book - Daily Entries screen

3. Select the Filter button (just next to the month selection buttons

4. In the dialog that appears set the filter as:

  • Option = Un presented transactions
  • Bank account = All accounts
  • Period = April to March (or what every your financial period is)

5. Select OK

This will display all the un presented items.

6. Select each unpresented transaction with your mouse and select OK
    This will automatically correct the transaction.

7. When complete select a Month and the Main bank account buttons to reset the screen filter.

The overall result of this issue only affected the Bank Reconciliation report so no other changes are required.

The Bank Reconciliation is an independent audit of your accounts and when it looks for un presented items, it looks for anything that is un presented where as other reports only recognise an item as being un presented if it is a cheque.

How can I print reports from a previous financial year?
 
  1. Go to Cash Book - Set up - Years
  2. At this screen you can select a Year
  3. Make sure you select the right year you wish to review
  4. When selected you will be asked if you want to edit the data.
  5. If yes you must type in the displayed password

This function only allows you to view the cash book until you exit the program.

When you re enter SoEasy it will automatically revert to the current year,

   
Company Assets
 
A staff member bought a company vehicle from us. How should I process the transaction?
  Treat the sale as a normal sale
  1. Add the employee to the database as a client (or use Cash Sales)
  2. Make up a GST Invoice for the vehicle.
  3. Add a NSI Item to the Invoice for the vehicle.
  4. Make the cost of the vehicle the book value at the time of sale
  5. Make the RRP the price sold to the employee.
  6. Treat the rest of the transaction as per a normal sale.

The effect of this is to increase sales.

Keep a copy of the invoice and present it to your accountant at the end of the year.
We will soon have the ability for you to post the transaction in the Accrual General Ledger but this is a complex transaction that should be left for a qualified accountant to process.

   
 
   
 

ask a question


copyright © The Matrix Trust 1991-2007 All rights reserved. Use of the software and resources is governed by the Software Licensing Agreement