Copy the data from the Ticket into template

(Use Paste Special and copy values), use conditional formatting to make sure all cell formats are matching

NOL upload, remove filtering before pasting into Generic upload spreadsheet. Then delete blank rows to make sure no journal is missed that was inadvertently filtered out in the spreadsheet attached to the ticket

1. Make sure data looks correct and save (this is journal entry, so the amounts should wash)

2. For NOL uploads, make sure the fund/op unit combinations balance.

3. Make sure every alpha field is all caps.

4. Make sure you close the file.

5. Open Monthly Entries Database

6. Click on the Step 0 Journals Tab

7. Enter Distribution Date, type in: Date that is inside Upload spreadsheet.

8. Click Tab button on keyboard

9. Click Upload Folder, to make sure txt file isn't in located. It would overwrite it

10. Go to Generic Transaction Upload section

11. Change the upload source to the source listed in the spreadsheet. EX: Ronda sent this spreadsheet, source is initials (RKD).

12. Click Import Data

13. Click Export Data

15. Make sure header and lines are okay.

NOTE: For June journals when the adjustment periods are open and period 12 is closed, change the journal date in the text file as follows (in Replace screen, put 3 spaces after the "Find what" value:

16. Click Replace All, then scroll through the rows to verify that the Replace yielded the correct result.

The 913 in the above example is the Adjustment Period code. Possible codes are:

997 - Monthly JE's from systems

913 - Late entries, corrects

914 - Any entries made on a work paper that are late entries every year

998 - Auditor adjustments

 17. If you are unsure of which adjustment code to use, ask the person who submitted the ticket.

 **NOTES** Verify that Header and Lines look correct. Every header will have at least two (journal) lines associated with it.

In this ticket example, I sent a snag it to Ronda, asking her to fix the one line issue.

https://okcfinance.jitbit.com/helpdesk/Ticket/20749702

If anything needs to be fixed, you will need to repeat the above import/export process.

Grants do not auto-reverse properly, so a single-sided entry gets made for the current month and then the accountant manually reverses the entry in the following month.

If you need to run the above process again to make a correction, it will overwrite what you did previously. You can rerun the process as many times as you need to.