lewismoten/wcfac-general-ledger
1
0
Fork 0
Code Issues 41 Pull requests Projects Releases Packages Wiki Activity Actions
Warren County Finance Audit Committee - General Ledger Viewer
170 commits 4 branches 0 tags 558 KiB
  • TypeScript 52.8%
  • PHP 34.9%
  • JavaScript 10.8%
  • CSS 1.2%
  • HTML 0.3%
Find a file
Exact
Lewis Moten 3e350ec542
 Merge branch '43-import-ap-ledger-data-from-foia-26-11'
2026-02-17 01:42:59 -05:00
data/chartOfAccounts convert accounts 2025-11-09 06:52:13 -05:00
db store in db #43 2026-02-17 01:03:38 -05:00
host Show reports based on paid date #43 2026-02-17 01:42:40 -05:00
public install vite with react typescript template 2025-11-09 06:09:40 -05:00
src Vendor concentration payments #38 2026-02-12 23:01:07 -05:00
utils wip - import endpoint dupe check #43 2026-02-13 03:57:36 -05:00
.gitignore show all views at once #37 2026-02-10 03:53:24 -05:00
eslint.config.js install vite with react typescript template 2025-11-09 06:09:40 -05:00
index.html change page title to Warren County General Ledger 2025-11-29 14:44:10 -05:00
LICENSE.md Initial commit 2025-11-09 06:04:12 -05:00
package-lock.json npm i xlsx (excel spreadsheet) 2025-12-12 23:04:39 -05:00
package.json wip - import endpoint dupe check #43 2026-02-13 03:57:36 -05:00
README.md convert accounts 2025-11-09 06:52:13 -05:00
tsconfig.app.json install vite with react typescript template 2025-11-09 06:09:40 -05:00
tsconfig.json install vite with react typescript template 2025-11-09 06:09:40 -05:00
tsconfig.node.json install vite with react typescript template 2025-11-09 06:09:40 -05:00
vite.config.ts Add pie chart 2025-12-11 17:22:59 -05:00

README.md

Chart of Accounts

  1. Locate all Chart of Account PDF files:

Files:

  • MAJORS (DEPARTMENTS).pdf
  • FUND NUMBERS.pdf
  • ACCOUNTS (OBJECTS).pdf
  1. Copy the text of the full document into corresponding txt files in ./data/chart-of-accounts/.
  • departments.txt
  • funds.txt
  • accounts.txt
  1. Remove all page headers such as:
11/07/2025 *GL065B* G/L CHART OF ACCOUNTS PAGE 1
WARREN COUNTY
Major# Description
------- -----------
  1. Run a script to convert all text files to JSON
npm run convert-chart-of-accounts