clear old Accounts payable
Comments
-
Hello Kevin
Perhaps Jamie would need to know how to do this?
If you are able to, can you advise how I can correct a journal I put through to creditors that was only to clear an outstanding amount not a Bill, it came about due to exchange rate and wasn't picked up for a while, so I did a journal and I had to put a suppliers name to it. Now its sitting as a credit against that supplier. Any thoughts of how to fix please?
Thanks
Pam
0 -
Hi Jamie & Pam
There are a few options depending on your particular circumstances ....
- Firstly, have these old amounts been reported as expenditure in prior ATO/government reporting (eg BASs, Tax Returns etc)?
& (if you're GST-registered) ....
- Do any include a GST component
- Are you reporting on a Cash or Accual basis (If you're unsure, check your BASs to confirm)
If so you will need to ensure you have an in/out trail in your transactions reflecting this upon "removal".
If you report on a Cash basis & have minimal overpayment transaction amounts (eg for ones under $10), I'd suggest just editing the original bill to match & re-ticking to re-allocate the overpayment. However, if you report on an Accruals basis - depending on what was lodged at the time - you may need to create a General Journal entry to reverse these. If you're not GST-registered & simply to remove these credits from your A/P ....
- Using the last date of current month/quarter/year as applicable, enter a GJ (crediting Accounts Payable) & select the applicable Supplier in the "Name" column. (The debit side can be posted to either Opening Balance Equity or a Suspense account if you would prefer to be able to pinpoint these for checking down the track)
If you ARE GST-registered & have previously reported these credits, you can offset this by debiting the same original account & tax code (as per the old, related bill) in your GJ.
- Once you've created the GJ, go into Pay Bills & you will see you now have a line in the list there for the applicable Supplier, representing your GJ. When highlighted/selected, you will also see the credit (overpayment) amount in Total Credits Available.
- Click on "Set Credits" to allocate & edit the Payment Date to match you GJ date, then click on "Pay Selected Bills" to process.
Pam, if you're using RA Premier or above, you may want to turn on multi-currency as RA enters the value difference automatically, posting it to an "Exchange Gain/Loss" expense account. Alternatively, you could create an additional GJ to move it to this account.
TIP: As you proceed, check the affected accounts to ensure amounts are debiting/crediting correctly & once you've got it right, memorise the GJ transaction(s) so you can easily re-use them if required.
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
1 -
Thank you Shaz. I do have multi-currency turned on and use Reckon Hosted. If I put another journal through to creditors this will leave a nil balance showing on the creditors listing but an amount in the Balance sheet. What I really need is to do a journal to creditors without putting a suppliers name but Reckon doesn't allow this. I wonder if I did a bill that coded the amount to exchange rate gain/loss and then allocate the credit to the bill? I'm going to try that. However I think the BS creditors account will still be wrong. I'll let you know. thanks
0 -
Hi Pam
".... If I put another journal through to creditors this will leave a nil balance showing on the creditors listing but an amount in the Balance sheet ..."
Are you referring to the Creditors Balance on the Balance Sheet or another account?
You will need to post individual GJs per Supplier if this amount outstanding relates to more than one.
Basically, you need to create each GJ & allocate according to the Supplier transactions that created the initial O/S balance(s) in your A/P.
Hope that helps.
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
0 -
Hi Shaz,
Thank you for your in depth explanation. Very much appreciated!
Its great to finally get the amounts off the ageing summary.
Thanks again0
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