Import Accrual journals with reversal

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

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).

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.

Hi Jo Thanks for your reply. But my question is if we can include the reversal journal in SAME FILE?

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.

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

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.

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

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.