How do I Contra Payment for Future Transaction while Year End Closing

How do I Contra Payment for Future Transaction while Year End Closing

Scenario

I have 2 Companies with same business partner, I had deal a sale transaction on 04/12/2012 and i got another deal as purchase on 15/01/2013 then i just directly use the receive to contra those transaction on 20/12/2013. After i done contra those transaction, I found that transaction doesn't show on my 31/12/2013 Balance Sheet!? The system doesn't show those future transaction in balance sheet?



Solution

Base on the Accounting logic concept, our OCI system wouldn't allow the future transaction to show in the balance sheet report, So we would advise to use this method for those user who need to contra future transaction.


Steps

As the condition the customer and supplier must be setup as same business then you would enable to use the contra method.
  1. Click -> SETUP -> CUSTOMER/VENDOR -> BUSINESS PARTNER

Now we start to create the Invoice as the date on 04/12/2012



And also create the Supplier Invoice on 15/01/2013



Now we going to contra those transaction
  1. Import in the Invoice that we created on 04/12/2012, after import click on MISC.

  2. Select an account as "prepayments" and put negative amount for deduct the outstanding amount
  3. Once you done to added receive voucher transaction, you may open it and check the Balance Sheet Report on 31/12/2012
  4. After we had settle the Balance Sheet Report issue, We need to contra the amount of the future transaction while the time become 15/01/2013 or later
  5. After select PAYMENT and import the Supplier Invoice you need to click on the EXPENSES to credit out the prepayment amount to contra with this transaction
  6. In the end once we done to contra the transaction and added the payment, we may check on the GL

    • Related Articles

    • Do you have Adjustments after Year End Closing?

      After Year End Closing (YEC) has been done, then you generate the P&L and tick 'include Current Year End closing' the value should be zero. If you made audit adjustments, then you may have values that were not included in the YEC. For example, FY ...
    • How to list Year End Closings?

      The Year End Closing  (YEC) module will generate GL entries. you can view these entries using the GL module. Assumption. I have only 1 retained earnings account  In GL module.  Set date range to Balance. Set account to retained earnings account. Set ...
    • How to do Year End Closing?

      Preparation The main purpose of Year End Closing process is to move the Profit/Loss amount incurred over the Financial Year (stored in Expense, Cost & Income accounts) to the Retained Earnings account. Ensure that all previous Financial Periods have ...
    • Accounting Year End Closing Training Guide

      Training PDF can be downloaded from 'Attachment' section below.
    • How do I contra payments between my 2 company and the same business partner?

      Scenario I have 2 Companies, ABC & DEF. Both share a Business Partner, XYZ. Company DEF has a Supplier Invoice to XYZ for $5000. Company ABC has an invoice to XYZ for $1000. I want to contra the $1000 XYZ owes ABC to the  amount DEF owes XYZ. ...