Accounts payable, A/R report & supplier balance not reconciling.
Selena Nicholson
Member Posts: 15 ✭
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
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
0
Comments
-
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.
Adrian0 -
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)
0 -
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 Selena0 -
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 Selena0 -
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.0
-
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)
0 -
Thanks Sally, I will have to get the admin details and log in. Thanks for your response.0
-
Hi Kathy,
Thanks for your response. I will try unlocking the periods and trying what you suggest.
Thanks Selena0 -
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
0 -
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.
Sally0 -
Hi Sally,
Thanks for your response, I followed your instructions and still get the error message above.
Any other ideas?
Thanks Selena0 -
Hi Selena,
Try running a Rebuild and Verify on your file, otherwise it may need to go to Reckon Data Recovery?
Sally0 -
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
0 -
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.
0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community