Separate Accounts and Payroll Databases (Enterprise 2018)

Mark Saunders_9755253
Mark Saunders_9755253 Member Posts: 3
edited September 2019 in Reckon Accounts (Desktop)
Hi Team, 

We are using Reckon Enterprise 2018 and our Database file is apx. 1.5Gb.
This has started to cause issues whereby when running Payroll, we cannot pull reports or access the Database as usual.
Recommendation has been to move Payroll Processing onto a new .QBW Database file and keep our Accounts processing on the original .QBW.
We will eventually have to move our Accounts Processing to a new Database (.QBW) as well.

Questions:
1. How do we create a new .QBW file specifically for Payroll?
2. What data would we need to export and import to make sure we can carry on with Payroll Processing as usual on the new Database file?
3. How would we arrange this data Export and Import.

Would really appreciate any guidance you could offer.

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited September 2019

    Hi Mark

    I wouldn't recommend moving just the Payroll to a separate file as you need payroll figures (in real time) within your company file financials!  Only Lists are able to be exported/imported - not transactions - so if you're going to start a new Company File, I'd advise doing so in its entirety (eg incl Payroll)

    There are a few things you can try first to decrease/optimise your company file including ....

    • Verify the Co File & Run Rebuild 3 times
    • Delete the .tlg File (Backup first!)
    • Re-sort all your Lists to their default order
    • Delete any transactions sitting in Print Queues
    • Defragment Co File DB & - if necessary - also your PC HD / Create & Restore Portable Co File
      Here's the latest link to Reckon's KB article on this:
      http://kb.reckon.com.au/issue_view.asp?ID=3793

      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

      shaz@accounted4.com.au

      https://accounted4.com.au

      (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!)