Knowledge Center logo

Supporting Materials and Source Inventory

The complete inventory of spreadsheets, templates, examples, PDFs, and training material in the source SharePoint library — and which ones still need converting.

Not every file in the source library became a page. Templates, example workbooks, and raw data files are more useful in their native format, so they stay in SharePoint and are indexed here instead.

Source library: SharePoint → Accounting Team → Shared Documents → Processes and Procedures

Converted to pages: 42 Word documents · Left as attachments: 32 spreadsheets, 3 CSVs, 6 PDFs, 1 HTML export, 1 video

Templates and examples

These are the working files staff actually open alongside a procedure.

FileAreaUsed with
Sales Entry Example.xlsxSalesSales journal entry
Bank Recon Balance Sheet Support.xlsxBank reconciliationBank reconciliation concepts
CC DIT R365 Template.xlsxCash and credit cardCredit card verification
DIT Example.xlsx, DIT Balance Sheet Examples.xlsx, Delivery DIT General Guidance.xlsxDelivery in transitDelivery in transit
Inventory and COGS Example.xlsxInventoryInventory and COGS
Book.xlsxFixed assetsFixed assets
Accrued Payroll Example.xlsxAccrued payrollPayroll concepts
Sales Tax Summary by State.xlsxSales taxAccrued sales tax
Sample Sales Tax BS Recons.xlsxSales taxAccrued sales tax
Sample Sales Tax Return Recons.xlsxSales taxAccrued sales tax
Trend Example.xlsxFinancial analysisFinancial analysis
Manual Check Log & Deposit Log Template.xlsxAccounts payableStuffing checks
AP Framework.xlsxAccounts payableAP overview
AP Training Checklist.xlsxAccounts payableOnboarding an AP team member

Sales Tax Summary by State.xlsx is the most broadly useful of these — it holds each state's rate, whether prepayments are required, and filing deadlines. Worth a look before filing in an unfamiliar state.

Delivery service process workbooks

The delivery in transit folder contains provider-specific reconciliation workbooks, plus a set of in-progress test versions.

FileProvider
Uber Delivery Recon Process using Payment Details.xlsxUber
DD Process Using Transaction Summary Reports.xlsxDoorDash
summarizedTransactions_*.csv (2 files)DoorDash — sample export data

A Process Tests subfolder holds seven workbooks with names like Door Dash Template-Rackson P8 In Progress, Grub Hub REC-Rackson Test, and Caleb Format P6 2022 - Door Dash Rec Raine. These are works in progress and personal test copies, not approved templates. The firm's own document list flags the DIT process docs as "Need to clean this up and update." Confirm with the accounting manager which workbook is current before using any of them.

Client-specific processes

FileClient
ROSE RESTAURANTS PROCESSES.xlsxRose Restaurants
URBAN ROOTS PROCESSES.xlsxUrban Roots
Freddy's Operations Playbook.pdfFreddy's
Freddy's R365 Vendor EDI Feeds.xlsxFreddy's

The MarginEdge invoice processing SOP is also client-specific — written for The Charter Oak Group.

Legacy documents

The AP department keeps a Legacy Docs folder. Treat these as historical unless someone confirms otherwise.

FileNotes
Check stuffing log.xlsxReferenced by Stuffing checks — confirm whether this is still the live log
EDI Vendors Current and Future.xlsxVendor EDI feed tracking
Plate IQ line item detail.xlsxPlate IQ line item data
Vendors to remove line item processing.csvVendor cleanup list
Large client invoices 1.1.23-9.30.23.xlsxHistorical invoice data, 26 MB

Training material

FileNotes
Factura Training.mp4674 MB video. Too large to host in the docs repo — link to it in SharePoint or move it to a video platform and embed.
PBI_Training.htmlA 10 MB single-file HTML export. Worth reviewing to see whether its content duplicates or extends these pages.
Payroll Quiz.docxConverted — see Payroll knowledge check
AP Training Checklist.xlsxAP onboarding checklist

PDFs not converted

Six PDFs were left as attachments. Reasons differ, and two are genuine gaps.

  • ERC Brew Vendor Letter (ACH Payments).pdf
  • ERC Brew ACH Payment Onboarding.pdf

Both are PDF versions of vendor onboarding letters that also exist as Word documents. Their content is consolidated into Vendor EFT onboarding letters.

  • Paystatement Example.pdf — an example pay statement, useful as a visual reference alongside Payroll concepts. Check it for real employee data before sharing it anywhere.
  • StatePaidSickLeaveLaws.pdf — a Department of Labor publication. Linked to the DOL source from Payroll concepts instead of being reproduced, so it stays current.
  • Freddy's Operations Playbook.pdf (3.3 MB) — a client-specific operations playbook. It likely warrants its own page or client section. Not yet reviewed.
  • Bank Auto Match.pdf (602 KB) — appears to cover the same ground as Bank transaction automation, but this has not been confirmed. Someone should check whether it holds anything the two bank automation pages don't.

Neither could be converted automatically — text extraction returned no usable content, which suggests they are image-based or scanned. Both need a person to read them.

Documents referenced but stored elsewhere

These are cited by the SOPs but live outside the Processes and Procedures library, in SharePoint → Accounting Team → Accounting Documents → 1099 Reporting:

FileReferenced by
W9 Mail Merger.xlsxAdd a new vendor — columns A–H must be completed for every potential 1099 vendor
What is a 1099 Transaction.docxAdd a new vendor — background for staff unfamiliar with 1099 vendors

The firm's own document list

Processes and Procedures Document List.docx tracked which concepts, examples, balance sheet recs, responsibility docs, and process docs existed per area.

This list has been superseded by this section's navigation. It was largely blank, several entries referenced filenames that no longer matched the library, and one carried the note "Need to clean this up and update." The gaps it revealed are recorded in Known gaps.