TRANXACT.AI मदत

Government finance

These features extend Accounting, Platform and the portals. Every new screen sits in an existing section; nothing adds a menu or a group.

These features extend Accounting, Platform and the portals. Every new screen sits in an existing section; nothing adds a menu or a group.

Budget preparation

Accounting › Budgeting › Budget Preparation, Budget Worksheets, Worksheet Lines, Decision Packages, Budget Issues

  1. New version: name it, choose the fiscal year and the kind (proposed, re-forecast, next year), and choose where it starts from. The options are zero, the original budget, the prior budget, the current (amended) budget, prior actuals, or average actuals over several years.
  2. Build fills one worksheet per department from that source. Adjust raises or lowers lines by a fixed amount or a percentage: across the whole budget, by department, by account or by account type.
  3. Departments enter worksheet lines in one of three ways: as an amount, as quantity × unit cost (Budget Unit Costs), or at the reduced, current or expanded level. Each line has a 500-character note and can be marked one-time. A one-time line must be approved (Decide one-time). Narratives and documents attach to the worksheet.
  4. Submit sends a worksheet to the budget office. After submission, or after the version's cut-off date, the department can no longer change it. The budget office can then Return, Review or Approve it. Lock / Unlock freezes a whole version at any stage. History shows every movement.
  5. Linked Budget Accounts: when one account changes, a notice is raised on the account linked to it (for example, a transfer pair).
  6. Consolidate totals the submitted worksheets by department, fund or Town-wide at any time, and lists the departments that have not submitted yet.
  7. Adopt writes the version into the active budget. The annual amounts can stay annual, or be spread evenly or by a monthly profile.
  8. Strategic Goals & Measures tie budget lines to the Town's goals.

Budget book

Accounting › Budgeting › Budget Preparation › Budget book

  • Produces the budget document in government format. It contains the transmittal letter, with merge fields such as {{total:expense}} that update with the figures; the sections and level of detail you choose; the attached narratives; and the GFOA criteria checklist.
  • Export (CSV or JSON) gives a budget-book platform the current figures on demand, so a re-run always reflects the latest version.

Forecasts and scenarios

Accounting › Budgeting › Budget Forecasts & Scenarios

  • Model methods: straight line, % of last year's actual, % of last budget, 2–5 year average, or user-defined. A model applies by line or to the whole budget. Models are saved by name and can be locked.
  • Current year forecasts the rest of the year, with adjustments. What-if changes one line or a group of lines. Multi-year projects ten or more years ahead.

Position (salary and benefit) budgeting

HRMS › Workforce Planning, with Accounting › Workforce Planning › Benefit Rates and Merit by Rating

  • Project budgets every position from live employees: class, grade and step, FTE, and start and stop dates. Merit increases apply by anniversary date, performance rating or step; market adjustments apply as a pay table or a percentage. Benefit rates recalculate cost by position, department and fund.
  • Scenarios are saved by name. Compare shows scenarios side by side.
  • Salary savings produces a budget adjustment from the savings. Push to budget loads the result into a budget version.

Year-end close

Accounting › Financial Close › Year-End Close and Year-End Encumbrance Close

  1. Preview, then Post. Revenue and expense close to fund balance, fund by fund. The run can be posted on any date after year end and repeated while both years are open; each new run reverses the previous one. Opening balances writes the new year's opening balances.
  2. In the encumbrance close, Load brings in the open POs. Set option decides, for each PO or for all at once, whether it lapses (is voided), is carried forward, or is carried forward with re-appropriation. Choose the method (GAAP, budgetary, or both) in Government Finance Settings. Post writes the carry-forward journal and its reversal on the first day of the new year.
  3. Encumbrance Reconciliation posts encumbrance control and reserve for encumbrance by fund, and reconciles them to the commitment ledger.

Government statements and the ACFR

Accounting › Reporting › Government Fund Statements, ACFR Line Mapping, OPEB & Pension Measurements

  • Render produces any of these statements, each on a cash, modified-accrual or full-accrual basis; Balance sheet; Revenues, expenditures and changes in fund balance by fund type; Net position; Activities; Budgetary comparison; Combining statements; Capital impairment (GASB 42); OPEB
  • Any line drills down to its accounts and journals. Export to PDF, Excel, Word, HTML, XML or CSV.
  • ACFR Line Mapping links statement lines to exhibits and notes. The SEFA statement lists federal awards with their ALN, grantor and pass-through id, the year's expenditures, and the amounts passed to subrecipients.

Grants and assets

  • Grant awards carry FAIN/SAIN, contacts, due dates and reporting frequency. Grant Subrecipients (Accounting › Fund Accounting) records each subrecipient, and Subrecipient activity reports their spending. Grant Funding Split applies source percentages (grant, local match, other) to each transaction.
  • Assets carry fund, funding source, grant-funded and donated flags, condition, square feet, and book value. Make idle stops depreciation and Reactivate resumes it. Assets by Grant splits an asset across several grants. Asset Fund Transfers moves an asset to another fund, with due to/due from.

देयके

  • Check Printing (Accounting › Payables & Receivables): Print checks pays the selected payments by check, numbered from the bank account's next check number, with one check per supplier or per invoice, a stub comment and an optional signature. Only users granted *check signing* can apply a signature. Zero and negative checks are refused. Check Layouts sets the stub fields and alignment offsets: Before the first check run is issued, the Town's bank must test the MICR print quality.
  • Paid checks from the bank: paste the bank's paid-items list (check number, amount, paid date) to clear those checks. A number the Town didn't issue, or an amount that doesn't match, is reported and not cleared. Outstanding checks downloads an aged workbook.
  • Positive Pay (Accounting › Cash Movement): issued and voided checks in American National Bank ARP CSV or fixed-80 format, downloaded or sent to the drop folder set in Bank File Folders.
  • 1099 Reportable Accounts sets which accounts and boxes are reportable. AP invoices › 1099: include / exclude leaves one invoice out. IRS TIN Matching produces the IRS bulk file and loads the results back. It needs the Town's IRS e-Services enrolment.
  • Card Merchant Categories (Accounting › Card Payments) allows, blocks or reviews MCC ranges. Card transactions are flagged as they arrive.
  • Purchase Orders › Blanket ceiling sets a blanket PO's ceiling, and the Contract field on a new AP invoice links it to a contract. Ceiling Draw-downs shows what each invoice used and what is left. Government Finance Settings decides whether an invoice over the ceiling is refused or recorded as over.
  • Supplier default account, cost center and fund fill new invoice lines that are left blank.

Cashiering and receivables

  • Cashiering (Accounting › Payables & Receivables) takes any receipt type: AR invoices, permits, licences, fees, records requests, taxes, or utility payments. It also works for a walk-in payer: Receipt Types set the revenue account and any extra distribution. A type with a standard fee and a Fee Proration rule is prorated from the start date to the program year end when no amount is entered: Payment Priority decides the order in which a partial payment is applied: Interest recalculates interest on overdue receivables to the payment date: Cashier Tenders limits which tenders each drawer or role can accept. Opening the drawer for a non-cash receipt needs a supervisor (*cashier overrides*): Transfer moves a receipt to another customer, approved by a second person: Email sends the receipt PDF.
  • Processor Settlements imports the processor's settlement file and matches it to receipts and deposits. Customer Refunds turns an approved refund into an AP payment.
  • Liens and Loans Receivable; liens with installment or balloon terms; amortization schedules; escrow; billing by coupon or statement; overpayments applied to principal; reports, including the 1098.

खजिन्या

  • Pooled Cash Interest (Accounting › Treasury): Calculate allocates earnings by each fund's average daily balance; you can exclude funds. Then Post.
  • Unclaimed Property; Scan finds uncashed checks older than the dormancy period. Checks the bank has paid are skipped; Send the due-diligence letters; Report produces the Texas Comptroller holder file; Then Remit or Claim.

Online payments (Elavon)

Platform › Payment Engines, provider *Elavon*

  • Enter the Town's Converge merchant id, user id and PIN, and make it the default engine.
  • Portal payments then go to Elavon's hosted page: utility bills and receivable invoices such as permits, licences, fines and assessments. TRANXACT never sees the card. When the payer comes back, the transaction is checked with Elavon before the account or invoice is credited.
  • Until the credentials are entered, the portals say that online payment is not set up.

Financial transparency

Accounting › Reporting › Financial Transparency

  • Switch it on, choose the address (slug) and decide what is shown: budget, revenue, expenditure, vendor payments, transactions. You can also hide payees below an amount.
  • The public pages need no login. They drill from fund to department to account to transaction and export to Excel, CSV and PDF.

Report subscriptions

Platform › Insight › Reporting › Report Subscriptions

  • Any saved report or view can run on a schedule: daily, weekly, bi-weekly, monthly, quarterly or at period close. It runs as its owner, so row security applies.
  • It is emailed as CSV, Excel, PDF or HTML to users and roles, and is also placed in My reports.
  • Run now runs it immediately. Every run is logged.

GIS and documents

  • ArcGIS Connections (Platform › Connectivity › Integration): enter the Town's ArcGIS Online client id and secret: Validate checks a premise address against the Town's layers and stores the lat/long, APN and match score. Validate all checks every premise: Not validated lists the exceptions. Override accepts an address by hand, with a reason.
  • Laserfiche (Platform › Data & Documents › Drives & Files): enter the Town's Laserfiche Cloud repository and credentials: Laserfiche Rules send a record type's documents, with their metadata template fields, on an event or a schedule. The archive log shows each push and its retries.

Security and settings

  • Admin › Roles › Idle sign-out (minutes): a role can sign its users out sooner than the company's idle timeout. When a user has several roles, the shortest timeout applies.
  • Accounting › Journals › Post manual journal takes a fund on each line. An entry that crosses funds posts with due to/due from lines and warns which funds it touched. For this, the chart needs *Due to other funds* and *Due from other funds* accounts.
  • Government Finance Settings; fund balance and encumbrance accounts; encumbrance posting; the cross-fund warning; the ceiling rule; the interest rate on receivables.

Second pass (release 20261115): receivables, payables, ledger reports and the town portal

Receivables

  • Customer groups (Accounting › Payables & Receivables › Customer Groups): each type of customer has its own receivable and revenue accounts, finance charge rule and statement cycle. Use *Put customers in this group* to assign customers.
  • Finance charges (Finance Charge Rules, Finance Charge Runs): set grace days, a monthly interest %, a flat fee for the first late charge, a minimum charge and a minimum balance. *Work out finance charges* as of a date, review the charges, then *Post*. The same month is never charged twice.
  • Customer statements: *Make statements* for any period, for chosen customers, a customer number range, a department, a group, delinquent accounts only, or those owing more than N days. Download all statements as one PDF, or the summary to Excel.
  • NSF returns: *Record an NSF return* with the receipt number. The receipt is reversed, the invoice reopens, the ordinance NSF fee (Government Finance Settings) is billed, and the customer becomes cash-only after the set number of returns.
  • Receipt batch reversals: reverse a whole lockbox file or batch at once, by its reference or by receipt numbers, with the reason.

देयके

  • Retainage: on an AP invoice, *Withhold retainage* (a % or an amount) moves it to the retainage payable account; it cannot be paid until *Release retainage*. *Reconcile AP and retainage to GL* compares the subledger with the general ledger.
  • Online and EFTPS payments: *Record an online / EFTPS payment* with the confirmation number. Each method posts to its own account (Payment Method Accounts). *Payments by method* totals them.
  • Manual checks: on Check Printing, *Enter a manual check* for a hand-written check; it joins the check register and the next positive pay file.
  • Voiding a range: *Void checks by number or range*, with the reason. Stale checks lists outstanding checks older than a number of days.
  • Form 1096: on 1099 Reportable Accounts, *Form 1096 (PDF)* gives the transmittal by form type.
  • Vendor inactivity: *Find idle vendors* with no activity for N months; a second person approves hiding or inactivating them.
  • Vendor changes with a reason: on a supplier, *Change with reason*; the Vendor Change Log keeps fields, before and after, who and why.
  • Payroll checks in positive pay: on Positive Pay, *Payroll checks file*.

Ledger and reports

  • Accounts that start and stop on a date: GL accounts have *In effect from* and *In effect to*; postings outside the dates are refused and *Apply effective dates* switches accounts on and off.
  • What if (try an entry) on Journals: balances and budget before and after, nothing posted.
  • Organization What-If (Financial Close): start from today's structure, change where cost centers roll up, and *Compare with today* for any period.
  • Encumbrance Adjustments: supplement, reduce or adjust a PO encumbrance or a requisition pre-encumbrance, with the reason and the balance before and after.
  • Reporting Groups: roll-up categories by account range, type, fund and department, each with effective dates; *Groups as of a date*.
  • Government Reports (Reporting): 26 reports -- available budget, cash, YTD and MTD expenditure, budget to actual, pre-encumbrances, open encumbrances, income statement, cash flow, net assets, trends, projects, and the monthly financial statements with Prior YTD, Adopted, Amendments, Amended, MTD, YTD, Actual to Amended and % Used -- each as PDF, Excel, CSV, Word, XML or HTML. Also the Schedule of Assets (by class, department and function, with disposals and gain/loss), Asset replacement, and Address 360.
  • Report Studio: *Show money* in thousands or millions; *Add calculated figure* to write a formula over key figures. Ledger postings can be cut by grant, program, function and project.
  • Grants: on a grant, *Life-to-date report* (and grant year, fiscal year, calendar year).
  • Asset Projects: an asset shared by several projects.

The town portal (CRM › Service & Engagement › Customer Portal)

  • Portal Branding: title, logo, colours, footer, link to the town website, map centre, analytics (Google Analytics 4 or Matomo, sent from the server), and whether residents may sign up online (a code is texted to their phone).
  • Portal Pages and Widgets: pages made of blocks -- text, events, disruptions, dashboards and reports from other applications, data feeds, maps, links, search. Signed-in residents drag blocks into their own order.
  • Portal Events (entered, or read from the town's iCal calendar under Portal Calendar Feeds), Portal Disruptions (*Tell residents* emails and texts those who asked), Portal Dashboards & Reports (only from hosts allowed in Branding), Portal Interests.
  • Portal Forms: residents save drafts, attach documents, and sign with their sign-in password where the form asks. Submissions and their documents are under Portal Form Submissions.
  • Portal Payment Rules: which methods, card brands and amounts are accepted for which payments. Residents pay several invoices in one payment and keep ACH bank accounts on *My account*.
  • Import residents from a file on Customer Portal Users, and Usage on Portal Branding.
  • The public portal is at /town/<company code>; signed-in residents find it under the *Town* tab.

<!-- from help-fvub.md -→