Sections

The workbook is split into two main sections with the use of clear section breaks. This the user to intuitively navigate the workbook. The Key also enables the user to understand the purpose of every cell increasing the speed of review and improving workflow.

CODE

Roll forward (VBA)

Each month most schedules (Sheets) require rolling forward.

Code

Split (VBA)

Each Sheet requires a separate Wb for individual upload to MyWorkPapers.

Code

Update Links (VBA)

Sometimes links do not update their relative file path when moving the file to next month’s folder.

Code

Export Journals (VBA & Formula)

Journals require noting on a schedule. These also require inputting into accounting software.

Code

Import TB (VBA)

An exported Trial Balance, from accounting software, requires pasting in several times a month.

Code

Emails (Formula)

Similar emails to managers, clients, preparers and partners require composing and sending each month.

Code

Sign Off

Each schedule completed requires sign off from the partner, manager and preparer.

Code

Return Placeholders

All PFM cells require returned for use at the start of each new month.

Code