Gone are the days of having to fiddle with invoice dates to get the correct spending records on your reconciliation report! Say arrivederci to needing to calculate fields required for OEC invoice templates! We know you won’t miss wondering if there are any records you did not include when billing your funder over the year!
Introducing the new and improved reconciliation process, available starting with reconciliation for December, 2020! This article is a quick overview of what is changing. To see the full instructions for this super-streamlined process, check out the Step by step Monthly Reconciliation Process Article!
Council must remember to do this process every month
Councils are reminded via an email to the grant lead to do this each month (easier)
Councils run 4 separate reconciliation reports, where they
Councils double-check their reconciliation reports (optional)
Councils save 1 action per funding stream and get report of exactly what they need (easier)
Manipulate the data in excel for each report to find the numbers that go in the invoice to OEC
New reports do this for you! (easier)
Put those numbers in OEC invoice (names of template do not always match how data appears in Sugar)
Councils copy-paste already appropriately summed and named fields into template for OEC invoice (easier)
Send invoice to OEC, as well as attach reports of spending/coaching records. If OEC wants to double-check, they have to re-aggregate all data from reports.
Councils send invoice and reports to OEC. OEC can easily double-check that invoice has been completed correctly using fields on reports (easier)
No easy way via Sugar to know for sure if Councils have successfully billed OEC for every record that they have spent their money on
Councils can easily check to make sure they have billed all records to OEC via the new "Billing Status" Field, and this process makes it almost impossible to miss any! (easier and cost-savings to Councils)
Councils must keep track of own reports.
Sugar stores each month’s report for future reference! (easier)