SNT Finance Organiser

Internal Finance Tool  |  All processing happens in your browser โ€” nothing uploaded externally

๐Ÿ“ค Invoice Blast
๐Ÿงพ Sales Invoice Bulk
๐Ÿฆ Bank Advice Sorter
๐Ÿ“ฆ Courier Invoice
๐Ÿงฎ Courier Bill Split
๐Ÿšš Trucking Invoice
โš™ Configuration
โšช Master config empty โ€” add rows in Configuration
โšช 0 emails configured
โš™ Open Configuration โ†’
1  ยท  Upload Files
Statement of Account (PDF)
๐Ÿ“„
Click or drop SOA PDF
Combined, all customers
Invoice (PDF)
๐Ÿงพ
Click or drop Invoice PDF
Combined, all customers
Transaction Lists (Excel)
๐Ÿ“Š
Drop files or folder here
One or more .xlsx per CustomerCode
โšช Master config empty
โšช GL codes not configured
โš™ Open Configuration โ†’
1  ยท  Upload Transaction Excel Files
๐Ÿ“Š
Drop transaction Excel files or folder here
e.g. HOMI_INV_2606_000120_โ€ฆ.xlsx โ€” one or hundreds
    1  ยท  Upload Files
    PV Letter (combined PDF)
    ๐Ÿ“„
    Click or drop PV Letter PDF
    Combined, all vouchers
    Bank Advice PDFs
    ๐Ÿฆ
    Drop bank advice files or folder here
    Vendor/PV matched via OCR of the scanned advice
    ๐Ÿ“ฆ Courier Invoice Organizer
    Import invoices from multiple couriers โ†’ consolidated Excel
    DHL DHL eCommerce
    ๐Ÿ“„
    Drop DHL eCommerce invoice
    .xlsx / .xls โ€” or click to browse
    SF SF Express
    ๐Ÿ“„
    Drop SF Express invoice
    .xlsx / .xls โ€” or click to browse
    TP Teleport
    ๐Ÿ“„
    Drop Teleport invoice
    .xlsx / .xls โ€” or click to browse
    J&T JNT Express
    ๐Ÿ“„
    Drop JNT Express invoice
    .xlsx / .xls โ€” or click to browse
    ๐Ÿงฎ Courier Bill Split โ€” DHL
    Attribute parcels to accounts, price at SNT sell rate, split billed Excel by debtor
    1. DHL eCommerce Invoice
    ๐Ÿ“„
    Drop DHL invoice
    .xlsx / .xls โ€” or click to browse
    2. Order List (account attribution)
    ๐Ÿ“‹
    Drop order list export
    .csv / .xlsx โ€” needs Reference No + Customer ID columns
    Attribution: tracking number โ†’ order list Customer ID โ†’ Debtor Code (via Customer ID(s) in Configuration). Falls back to the DHL invoice's own Project column for lines the order list doesn't cover. Pricing uses the Courier Sell-Rate Card in Configuration.
    ๐Ÿšš Litt Tatt Trucking Invoice โ†’ Excel
    Scanned vendor invoices (OCR) โ†’ consolidated Excel, one row per line item
    ๐Ÿšš
    Drop Litt Tatt invoice PDFs or folder here
    Scanned PDFs โ€” OCR runs in your browser, nothing uploaded
    OCR of scanned invoices is best-effort โ€” you'll review and edit every row before exporting.
    Master Configuration 0 rows โŸณ Connectingโ€ฆ
    One row per debtor. Debtor Code = AutoCount key (e.g. 02TD-H010). CustomerCode(s) = semicolon-separated (e.g. HOMI;HOMI_SG) โ€” used for folder names and Excel filename matching.
    0
    Debtors
    0
    Emails set
    0
    CustomerCodes mapped
    0
    ItemCodes set
    No rows yet. Click + Add Row to start, or Import CSV to load a saved configuration.
    Sales Invoice โ€” Item Code Mapping Description in transaction โ†’ ItemCode in AutoCount
    Each row maps one Description โ†’ ItemCode. The description in the transaction Excel is matched exactly (case-insensitive) against this list. Add rows as your charge types grow.
    Item CodeAC DescriptioneHub DescriptionItem GroupSales Code
    SST / Tax line
    FieldValue
    SST AccNo
    SST line label
    SST Tax Code
    SST AccNo is written directly to the AutoCount import for the tax line only. All other charge lines get their AccNo from the AutoCount item master via ItemCode.
    Courier Sell-Rate Card Debtor Code ร— Zone/Weight-band โ†’ sell rate, used by Courier Bill Split โŸณ Connectingโ€ฆ
    One row per Debtor Code ร— zone (ZN1โ€“ZN6) or weight band (>1 - 2). Charge = Base RM + max(0, weight โˆ’ Included Kg) ร— Subsequent RM/kg. Leave Included Kg / Subsequent RM blank for a flat per-parcel rate. Category is optional โ€” for accounts whose whole rate grid changes at a weight threshold, set it to something like <30KG / >30KG or >2.0 & <5.01; the row only applies when the parcel's weight matches. Leave Category blank for rows that apply regardless of weight (the common case). Debtor Code autocompletes from Master Configuration; Company shows what that code resolves to, live, so a wrong/orphaned code is obvious at a glance. Rows with an orange-bordered Debtor Code don't match a row in Master Configuration above. Rows with an orange-bordered Category aren't a recognized weight threshold (e.g. region-qualified like >30kg - KV) โ€” they're kept visible but never auto-selected for pricing until fixed.

    This card is centrally managed from a published Google Sheet and re-synced on every page load (or via โŸณ Sync Sheet). A successful sync replaces the whole card with the sheet's contents, so edit rates in the central sheet โ€” local edits here are for quick testing only and are overwritten on the next sync.