Accounts payable, A/R report & supplier balance not reconciling.

Selena Nicholson
Selena Nicholson Member Posts: 15
edited February 2017 in Accounts Hosted
Hi All, 

I am trying to reconcile my balance sheet and have a variance between the Accounts Payable, the AP Aging Summary report and the supplier balances report. 

I am using Reckon Accounts Hosted 2015 R2.  

I have attached screenshots of all the balances. 

The issue I am having is due to the creditor "Abattoirs" for -$196.20. I have tried to enter a bill to offset this amount, but that changes both the balance sheet and A/P aging report balances. Also, when I go to pay the bill, this supplier has credits of $207.10?!

I have attempted to edit the current balance per the instructions in Reckon and can't find where the opening balance transaction was recorded in the register.

Any assistance greatly appreciated.

Thanks Selena 


image


image

image


Comments

  • Adrian_6974554
    Adrian_6974554 Member Posts: 191 ✭✭
    edited February 2017
    Hello Selena

    It will due to a corrupt transactions.

    Make sure you keep a copy of the details of each transaction.

    You will need to delete the transaction that created the credit, and if that credit was part offset against other transactions, they will also need to be deleted.

    Run a rebuild of the data file, then renter in the transactions, and offset as applicable.

    Adrian
  • Sally McIntosh, Accredited Consultant
    Sally McIntosh, Accredited Consultant Accredited Partner Posts: 468 Accredited Partner Accredited Partner
    edited February 2017
    Hi Selena,
    Is there negative lines entered on any of the bills for Abattoirs? 
    Is it setup for multicurrency i.e. an overseas $value amount?
    If you look at the Open Balance in the supplier centre, can you see anything?
    Kind regards,
    Sally McIntosh (sally@samsolutions.com.au)
  • Selena Nicholson
    Selena Nicholson Member Posts: 15
    edited February 2017
    Hi Adrian, 

    Thanks for your response, I shall try that this afternoon.

    Hi Sally, 

    No, the file is not set up for multi currency, the open balance in the supplier centre is $0.00. I will check this afternoon to see if there are any negative lines entered in the bills.

    Thanks Selena 
  • Selena Nicholson
    Selena Nicholson Member Posts: 15
    edited February 2017
    Hi again,

    The transaction that is corrupt is in a prior period and there accounts have been locked with a password. I am not aware of the password and unsure if my client would remember it. 

    Is there anything else I can do aside from deleting the transaction?

    Thanks Selena 
  • Kathy Mackinlay_6947388
    Kathy Mackinlay_6947388 Member Posts: 141
    edited September 2015
    I had a similar situation and it was to do with dates. From memory I ran an audit report and found that i had applied an earlier transaction to a later date. (A payment from earlier date applied to a credit note recently put in.) I unapplied and just left the two amounts to equal nil. Otherwise you could change the date of the credit. Hope this helps.
  • Sally McIntosh, Accredited Consultant
    Sally McIntosh, Accredited Consultant Accredited Partner Posts: 468 Accredited Partner Accredited Partner
    edited December 2016
    Hi Selena,
    If you are logged in as admin you can easily change the date and password.
    Company drop down menu > Set closing date > change date/password.
    Kind regards,
    Sally McIntosh (sally@samsolutions.com.au)
  • Selena Nicholson
    Selena Nicholson Member Posts: 15
    edited October 2015
    Thanks Sally, I will have to get the admin details and log in. Thanks for your response.
  • Selena Nicholson
    Selena Nicholson Member Posts: 15
    edited February 2017
    Hi Kathy, 

    Thanks for your response. I will try unlocking the periods and trying what you suggest. 

    Thanks Selena 
  • Selena Nicholson
    Selena Nicholson Member Posts: 15
    edited February 2017
    Hi All, 

    I have been able to unlock the period and change the dates on invoices that were paid and the invoices were dated after the payment date.

    I have also identified the corrupt transaction and am trying to delete this transaction to re-enter. When I confirm deletion of this invoice I receive the following error message and once I select "Close" Reckon closes. I have tried to delete the invoice multiple times and Reckon keeps closing.

    Any ideas on what I need to do to delete this invoice?

    Kind regards, 

    Selena 

    image
  • Sally McIntosh, Accredited Consultant
    Sally McIntosh, Accredited Consultant Accredited Partner Posts: 468 Accredited Partner Accredited Partner
    edited December 2016
    Hi Selena,
    You will find you need to delete this transaction from the register. I.e. if it is a bill double click on your Accounts payable account, find and highlight (by clicking once) on the transaction, then from the edit drop down menu you can delete it.
    If it is a bill payment, then do the same but from the bank account register
    I hope this helps.
    Sally
  • Selena Nicholson
    Selena Nicholson Member Posts: 15
    edited October 2015
    Hi Sally, 

    Thanks for your response, I followed your instructions and still get the error message above.

    Any other ideas?

    Thanks Selena 
  • Sally McIntosh, Accredited Consultant
    Sally McIntosh, Accredited Consultant Accredited Partner Posts: 468 Accredited Partner Accredited Partner
    edited December 2016
    Hi Selena,
    Try running a Rebuild and Verify on your file, otherwise it may need to go to Reckon Data Recovery?
    Sally 
  • user004
    user004 Member Posts: 1
    edited March 2016
    Hi there,

    I wanted to offset creditor invoices against journal.

    Once all allocated, amounts column is zero but still show 16k open??!

    Not a fan of reckon at all.

    Cheers,

    User 004





  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited February 2017
    Hi User004,

    Welcome to the Reckon Community.

    If I understand you correctly, you have entered a General Journal to offset an outstanding Supplier (creditor) balance.  The balance for the Supplier is now showing zero, but you still get indications that this Supplier has unpaid invoices.

    Did you "Pay Bills" for this Supplier and apply the credit created by the General Journal?  its this process that marks the creditor invoice as Paid.



    I hope this addresses the issue.


    regards,
    John.