Revenue

Local Dev Friday, Feb 20
person

Process Revenue Data

Upload billing exports to generate NetSuite journal entries

1
Upload
2
Review
3
Process
4
Results
build Test Mode Active - Files auto-loaded from settings Configure
cloud_upload

Upload Revenue File

cloud_upload

Drop your Excel file here

.xlsx or .xls accepted

attach_file

Bank Account File

Optional - drag & drop or click to upload .xlsx

Current: Bankaccount.xlsx
Calculates difference between revenue and bank deposits
info Period and fiscal year will be automatically detected from the transaction dates in your file.
info

How it works: The revenue file is processed in three steps:

1. Enrichment - Transactions are mapped to payer types, departments, and location codes using configuration
2. Aggregation - Transactions are grouped by location, department, and payer type for journal entry lines
3. JE Generation - One CSV per location with credit lines per Department×PayerType and a debit to clearing (18099)

Unposted JEs: When enabled, calculates the difference between revenue and bank deposits to generate unposted journal entries.