http://m.getsatisfaction.com/topics/7777223 Separate Accounts and Payroll Databases (Enterprise 2018) 2018-08-13T06:38:09Z 2018-08-13T05:07:55Z 7777223 http://m.getsatisfaction.com/topics/7777223 7777223 Separate Accounts and Payroll Databases (Enterprise 2018) 2018-08-13T06:38:09Z 2018-08-13T05:07:55Z Mark Saunders http://m.getsatisfaction.com/people/9755253 https://www.gravatar.com/avatar/18e3fdba422379c4b1c0926e8e47a223?d=identicon&s=55&r=PG mark_saunders_dgoqs1g1t3drg Hi Team,&nbsp;<br /><br />We are using Reckon Enterprise 2018 and our Database file is apx. 1.5Gb.<br />This has started to cause issues whereby when running Payroll, we cannot pull reports or access the Database as usual.<br />Recommendation has been to move Payroll Processing onto a new .QBW Database file and keep our Accounts processing on the original .QBW.<br />We will eventually have to move our Accounts Processing to a new Database (.QBW) as well.<br /><br />Questions:<br />1. How do we create a new .QBW file specifically for Payroll?<br />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?<br />3. How would we arrange this data Export and Import.<br /><br />Would really appreciate any guidance you could offer. question 1 2 1 comment http://m.getsatisfaction.com/topics/7777223/replies/19692848 http://m.getsatisfaction.com/topics/7777223 19692848 Acctd 4 (Shaz) (Reckon Accredited Bookkeeper/Regd BAS Agent) responded to "Separate Accounts and Payroll Databases (Enterprise 2018)" 2018-08-13T06:38:09Z 2018-08-13T06:38:09Z Acctd 4 (Shaz) (Reckon Accredited Bookkeeper/Regd BAS Agent) http://m.getsatisfaction.com/people/4372472 https://graph.facebook.com/564477472/picture?type=normal acctd_4 <p alt="" name="" rel="" target="" title="" type="" value="">Hi Mark<br alt="" name="" rel="" target="" title="" type="" value="" /> <br alt="" name="" rel="" target="" title="" type="" value="" /> I wouldn't recommend moving <b alt="" name="" rel="" target="" title="" type="" value=""><i alt="" name="" rel="" target="" title="" type="" value=""><u alt="" name="" rel="" target="" title="" type="" value="">just</u></i></b> the Payroll to a separate file as you need&nbsp;payroll figures (in real time) within your company file financials!&nbsp; Only Lists are able to be exported/imported - not transactions -&nbsp;so if you're going to start a new Company File, I'd advise doing so in its entirety (eg incl Payroll)</p> <p alt="" name="" rel="" target="" title="" type="" value="">There are a few things you can try first to decrease/optimise your company file including ....</p> <ul alt="" name="" rel="" target="" title="" type="disc" value=""> <li alt="" name="" rel="" target="" title="" type="" value="1">Verify the Co File &amp; Run Rebuild 3 times</li> <li alt="" name="" rel="" target="" title="" type="" value="1">Delete the .tlg File (Backup first!)</li> <li alt="" name="" rel="" target="" title="" type="" value="1">Re-sort all your Lists to their default order</li> <li alt="" name="" rel="" target="" title="" type="" value="1">Delete any transactions sitting in Print Queues</li> <li alt="" name="" rel="" target="" title="" type="" value="1">Defragment Co File DB &amp; - if necessary - also your PC HD / Create &amp; Restore Portable Co File</li> </ul><ul alt="" name="" rel="" target="" title="" type="disc" value=""> </ul> Here's the latest link to&nbsp;Reckon's KB article on this:<br alt="" name="" rel="" target="" title="" type="" value="" /><a alt="" href="http://kb.reckon.com.au/issue_view.asp?ID=3793" rel="nofollow" target="" title="Link httpkbreckoncomauissue_viewaspID3793" type="" value="">http://kb.reckon.com.au/issue_view.asp?ID=3793</a><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Hope that helps.<br alt="" name="" rel="" target="" title="" type="" value="" /> 0