How to Reclassify (Change Classes) Multiple Transactions in Bulk

Options
Paul Chapman_10166275
Paul Chapman_10166275 Member Posts: 3 ✭
edited July 2020 in Reckon Accounts (Desktop)
We are running Reckon Accounts Premier - Non-Profit Edition 2019.

We have multiple Payroll Item transactions that show up as "Unclassified" on Class reports. We want to change these to the correct class. We have 15 employees, thus we have 390 F/N paychecks to edit for the past financial year.

Is it possible to reclassify (change the Class) for these transactions in bulk rather than one-by-one (paycheck by paycheck)?

Here's what happened that led to this issue.

Under Company preferences, we set the program to assign one class per "Earnings Item".

However, Employees were set up without a Class assigned on their Payroll info screen.

This led to some payroll items under the "Other Payroll Items" input area not being assigned to a class.

To fix it, currently, we have to change the Company preference to assign one class per "Entire paycheck". Then we open each paycheck and select a Class from the respective field at the top right of the preview paycheck screen. Then save and close. 

This is very time consuming considering we have 390 paychecks to do. Is there a quicker way? Some kind of bulk editing feature for assigning classes?


Any help appreciated.

Thanks.
PaulC


 

Comments

  • Linda ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    edited July 2020
    Options
    Unfortunately each entry will need to be changed - but I am wondering about the value of what you have been doing - if this has gone unnoticed for a whole year?  does this mean you have not required this information on reports all this time?  maybe a rethink of why you are doing this?  or, if the reports for this year are completed - maybe just make sure its done correctly for this year?  and if allocating one class per paycheque now is sufficient - then I would be leaving the preferences set to one class per paycheque - then assign a default class to the employees so that its automatic in future?
  • John Graetz
    John Graetz Member Posts: 1,651 ✭✭✭
    edited August 2019
    Options
    One other thought to add to what Linda has said.  If you can readily determine what the actual values are for each class that you need to correct (perhaps you could see what the corrections need to be by dumping the info into a spread sheet) you could then do a simple journal to transfer the value out of the unclassified class into the respective correct classes - that should save a heap of time.
    John L G
  • Paul Chapman_10166275
    Paul Chapman_10166275 Member Posts: 3 ✭
    edited August 2019
    Options
    Thanks Linda. We have been in a transition period for the past 6 months, transferring our Fund based accounting system from Excel Workbooks to Reckon. We had a backlog of transactions to transfer over to the Reckon program, and have been running both systems side by side for the past 3 months or so. 

    Our inhouse treasurer, has asked for the unclassified transactions to be cleaned up, as this is vital to our Fund Based Accounting system to verify that we have every transaction in the correct Fund ("Class"), both for Balance Sheet, and P&L, as we run Fund balances, including equity splits. 

    Our employees split time between Funds ("Classes"), and one of these being external to us, we need to track their costs against that Fund in order to account for monies other Funds owe the Fund or monies the Fund owes other Funds.  

    So, yes, moving forward, into this year, things are working out with Company payroll preferences set to assign one class per item, and each Employee record set to assign paychecks to a default class.


  • Paul Chapman_10166275
    Paul Chapman_10166275 Member Posts: 3 ✭
    edited August 2019
    Options
    Thanks John. Yes, I fell back to a single journal entry of the totals for each month (using a payroll item fast report, I can bring up the details of all unclassified transactions for that item). So for monthly Financial Position and Performance reports, this will suffice. 
    Cheers.

Categories