Sage 200 UKI Ideas Portal

Import Accrual journals with reversal

Has anyone tried importing Accrual in month end and adding reversal journal with next month date?

  • Sumit Pradhanang
  • Dec 10 2023
  • Already Exists
Idea Benefit Will save time reversing journal next month
How do you solve for this problem today? Just want to know if anyone has tried this
  • Gordon Bell commented
    20 Dec, 2023 02:38pm

    Hi, I have tested posting the journals on the same import file with the different period dated journals and this would work, if you are processing your accruals manually.

    However, If its for timesaving, there is a process for automatic accruals in sage the guides can be found here:

    (Sage 200 Standard): https://desktophelp.sage.co.uk/sage200/sage200standard/Content/Concepts/PrepaymentsAccrualsIntro.htm?Highlight=accruals

    (Sage 200 Pro):

    https://desktophelp.sage.co.uk/sage200/professional/Content/NL/Record_Prepayments_and_Accruals.htm?Highlight=accruals

    Thanks



  • Sanjay Pancholi commented
    18 Dec, 2023 12:51pm

    Hi, yes we do this all the time. On the Excel import template, you have the entry for the current month with the current period dates, and directly below on the same journal/file, you have the reversal (i.e. opposite of the original entry) - the only difference being on these lines the "Transaction Date" column needs to be in the following month (i.e. the period you are reversing the entry into).

  • Tony Davis-Coyle commented
    12 Dec, 2023 08:33pm

    Why not create a template journal, then post as a reversing journal?


    If this is for GRNI from POP there is an Order and Returns Accruals routine in POP Maintenance.

  • Sumit Pradhanang commented
    12 Dec, 2023 06:44pm
    Hi Jo Thanks for your reply. But my question is if we can include the reversal journal in SAME FILE?
  • Jo Kirkup commented
    12 Dec, 2023 06:38pm

    my apologies, yes you can import journals that affect your nominal codes for accruals, to reverse them you would simply create a template file for your journals and then transpose/ swap your debit & credit values around and adjust your dates. This would be nominal transactions, information is in this helpfile page - it cannot do the reversal automatically which is why I've left the idea open for voting.

  • Sumit Pradhanang commented
    12 Dec, 2023 05:07pm

    Thanks Jo for taking this forward. You still have not answered my question. Are we able to do this currently on sage 200? Thanks again Sumit

  • Jo Kirkup commented
    12 Dec, 2023 02:59pm

    thanks for the reply, I understand. I've marked this as accepted so we'll leave it open for voting to see if its something the rest of the customer base are looking for.

  • Sumit Pradhanang commented
    12 Dec, 2023 01:28pm

    Hi Jo Thanks for coming back. My question is can you add the reversal on same journal with reversal date being next period. This way we can save time in uploading reversal journal. Thanks again Sumit

  • Jo Kirkup commented
    12 Dec, 2023 11:20am

    Can you provide more information on what functionality you are seeking? You can import journals, you could then repeat the import the following month with the relevant date and DR/CR values transposed.