Reconciling Accounts - Payroll - Switch Prior Checks to Online Deposit?
The previous office manager would record employee payments by creating "paychecks" in Reckon. However, the paychecks were not distributed, the pay was instead, automatically deposited to the employee's bank accounts by the boss.
This has created an issue when reconciling the bank statement in Reckon, because it looks like the payroll has already been cleared via checks, and it will not allow me to match the imported payroll data from the bank statement to the data from the paychecks stored in Reckon.
I am totally new to this software, so please forgive my ignorance.
Is there a way to change the previous "paychecks" to note they have been deposited online?
The boss wants to continue making the payments himself via online banking, but we need to have these payments recorded in Reckon.
Thanks so much!
I was going to start importing my bank statements - can anyone answer this question? I don't want to create more problems by using this facility. What is the alternative to paying staff by a direct EFTransfer? Can you pay through Reckon?0
Acctd4 Accredited Partner Posts: 2,370 Reckon Accounts Hosted Expert
Hi Accounts NZ & Michelle
The term “Paycheque” is simply a type of transaction, being - in this case - a payment to an employee. Correctly processing Pays via the Payroll feature in RA creates these.
If the pays have already been made in 1 bulk EFT payment, you can choose to create & utilise a “Clearing Bank Account” in RA to reflect this more accurately on your bank reconciliation.
A Clearing account is a dummy bank account that you can use to pay individual transactions into/out of & use a “Write Chq” to transfer the lump sum amounts, always returning this account to $ 0.00.
Another option for actually distributing bill payments &/or wage payments is by creating & uploading an “ABA File”. This is a specially formatted file that is compatible with your bank’s online system.
To use ABA Files, you must have the Payee’s Bank account details completed in their RA record (Supplier or Employee)
The correct transaction is still made first in RA – eg Paycheque, Bill Payment – then you create & save an ABA File, login to your online banking & upload this file which the bank system is able to read & “pay” as per the payee’s bank details (which are automatically included in the ABA file)
Bank Feeds (“Importing”)
Importing (often also referred to as “Bank Feeds” nowadays) is another method of recording data, however this is simply pulling in transactions that have already happened (eg as per your online banking transaction history) & creating “Rules” in your software to tell RA how to categorise them.
Be mindful that a lot of errors can occur using this method if you don’t have the setup correct!
In order to set up Bank Feeds, you need to register for Reckon’s BankData which starts from $ 3 p/mth:
(Personally, I find using auto-recall along with auto-entry Memorised Transactions covers a large portion of transactions. Bill Payments & Pays (“Paycheques”) aren’t able to be auto-filled or memorised but I’m just pedantic in terms of formatting & don’t want to import data that doesn’t match the rest of my file eg all uppercase v mixed lol )Write a reply
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
0422 886 003
(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
Accounts NZ Member Posts: 36 ✭Thank you so much Shaz for your detailed reply! I really appreciate your time and expert advice!2
Yes, thanks. Really appreciate it.0
- 18.3K All Categories
- 6.3K Accounts Hosted
- 5.7K Reckon Accounts (Desktop)
- 10 PaySauce for Reckon Accounts NZ
- 981 Reckon Payroll App
- 12 Payroll App - Help Videos
- 13 Reckon Mate App
- 2.9K Reckon One
- 8 Reckon Invoices App
- 12 Reckon Insights
- 105 Reckon API
- 775 Payroll Premier
- 290 Point of Sale (Desktop)
- 1.8K Personal Plus and Home & Business
- 58 About Reckon Community