Calculating The Society project interests is based on project’s cash balance as of current month-end at Vancity’s interest rate, and charge overhead on interest earned.

1. Open the prior month interest worksheet
2. Save as: “MM Interest allocation” in Box
3. Run the NetSuite Saved Search “MakeWay Project Cash Balance (Interest Allocation) for the date range ending the current period:
   • Get Vancity interest rate from monthly Vancity interest summary
   • Calculate the project interest
   • Copy NetSuite Designation List
   • Add a column and use vlookup function to get project designation internal ID
4. Save the worksheet.
5. Open MM 2017 Project Interest Uploading  CSV file
   • Enter new month’s information
   • Copy the amount and internal ID from worksheet and paste into uploading file.
6. Save the file in CSV format.
7. Once the file is saved, open NetSuite
8. Navigate to Setup > Import/Export > Saved CSV Imports
9. select Saved CSV Import “MakeWay-Standard Journal Entry”
10. Following the standard import process.