I have a client that running ADP payroll. They take the first PR JE for the month and determine how much belongs in the prior month. The JE is posted in TOTAL for the month and a second one is posted for the accrual in the prior month and reversed on the same date as the full month JE. You could do the same thing for your client. To make is simple, DON'T let MAS do the accrual at all. Post the entire entry in the new month. Do the accrual for the prior month and reverse. To capture the JE in Excel, run a query against the DTR prior to updating to the GL. In Excel, determine accrual then import using VI. Reverse on the appropriate date by populating the reversing JE field.