How to Run Seraph Invoice Process

Seraph updates the Data System master spreadsheet on Dropbox

(1) Tab for management fees is updated for any items paid since last invoice process (2) Tab for investor info is updated for any new investors

Access Dropbox and open necessary files

(1) SC dev can open in a "PC" using the Amazon WorkSpaces account for a virtual machine (2) Open Seraph Group Team Folder > Seraph Transition Files > Data System > Data System v[41].xls

Create new Dropbox sub-folders for this run of the invoice process

(1) New year folder: Seraph Group Team Folder > Seraph Transition Files > Invoices > Capital Call Invoices > [2018] (2) New month folder: Seraph Group Team Folder > Seraph Transition Files > Invoices > Capital Call Invoices > [2018] > [April] (3) New sub-folders for each fund: Seraph Group Team Folder > Seraph Transition Files > Invoices > Capital Call Invoices > [2018] > [VII]

Create new invoice template for this run of the invoice process

(1) Roll forward the invoice template from a prior run (2) Name the file: Seraph Group Team Folder > Seraph Transition Files > Invoices > Capital Call Invoices > [invoice-template-april.xls]

Fix Excel links in invoice template until they are not broken

(1) Check tab "Calculations" for proper reference to Data System workbook (2) Check tab "Inputs" for proper dates (Column A) to be confirmed by Seraph: Invoice Date, EarlyFundsInvoiceDate,Last Invoice Date, Last Cap Call Date (3) Check tab "Inputs" for proper management fee rates (Column I) to be confirmed by Seraph (4) Check tab "Invoice" and confirm with Seraph if any updates to static language, such as wire transfer details or footnotes

Sort and filter the tab "Calculations"

(1) In the column Capital Fall Filter (Column K), delete the "Prevent" text, if the process should include Capital Calls (2) In the column Total Invoice Flag (Column AC), filter by records with Yes (3) In the column Fund (Column F), sort records by A to Z descending

Copy sorted names to tab "ToBeInvoicedRoster"

(1) In tab Calculations, copy-and-paste the names for each fund to the proper column in tab ToBeInvoicedRoster.

Copy all names to tab "PostToDS"

(1) In tab Calculations, copy-and-paste the entire column of names to the tab "PostToDS MgmtFees" and "PostToDS CapCalls", this will populate the remaining columns which match Data System columns

Run the macro in the invoice template

(1) Navigate to View > Macros > pdfProduce (2) Update macro filepath where you want PDFs to be created for example, ...Seraph Group Team Folder\Seraph Transition Files\Invoices\Management Fees\2018\April... (3) Click "Run" > Input the fund number What happens? Macro runs through the name column in "ToBeInvoicedRoster" corresponding to the fund number you input. Macro uses name as key. Creates PDF using tab "Invoice" for each name in that fund

Seraph reviews PDF invoices on Dropbox

(1) Tricia or other personnel will put some in "Hold" folder which are not to be sent

Send emails with PDF attachment

(1) Update tab "invoices" for any new investors (2) Update invoices.rb script for proper Dropbox path to grab files (3) Use invoices "tab" as a CSV for the invoices.rb email script

Check tabs "PostToDS"

(1) In PostToDS tabs update the date (Column F) to today's date (e.g., 4/30/2018) and copy and paste down (2) In PostToDS tabs deselect the empty values ( - ) in Column I so that only records with values show

Seraph can update Data System management fees tab

(1) The invoice template populates the tabs "PostToDS MgmtFees" and "PostToDS CapCalls" (2) Seraph can copy-and-paste this into Data System