Skip to content

Accounting

The general ledger behind every delivery, bill and payment, plus the chart of accounts, periods and month-end close.

Accounting is the general ledger. With the ledger turned on, every posted delivery invoice, supplier bill, payment, credit memo, stock count and depreciation run writes a balanced journal entry here, so the bookkeeper can close each month and run the financial statements without re-keying anything.

How to tell where Accounting opens when the general ledger is on or off

Opening Accounting takes you to Reporting when the general ledger is on, and to Chart of Accounts when it is off. The switch is the General Ledger setting under Settings, then Accounting. With the ledger off, deliveries, receipts and invoices still work and quantities still move, but no journal entries are written: the chart of accounts shows no balance column and offers no Opening Balances button.

How to find your way around Accounting when you open the sidebar

GroupPageWhat it is for
ReportsReportingThe list of financial statements and analysis reports (reports)
ReportsSync Tie-OutChecks postings against Rillet; shown only while an accounting integration is connected
General LedgerIntercompanyTrades between companies in the same group; shown only when the group holds more than one company
General LedgerJournal EntriesEvery entry, and the manual ones you write (journal entries)
General LedgerAccounting PeriodsMonths, their close checklist, lock and close
Fixed AssetsAssets, DepreciationTrucks, bulk tanks and equipment on the books (fixed assets)
ConfigureAsset Classes, Chart of Accounts, Cost Centers, Default Accounts, Dimensions, Exchange Rates, Fiscal Year, Payment Terms, ProjectsThe settings every posting relies on

Every page needs the employee role.

How to set up the chart of accounts when you start

  1. Open Chart of Accounts. Accounts sit in groups drawn as folders under two fixed root groups, Balance Sheet and Income Statement. Each account shows its Account Number and Name; with the ledger on, a Balance column shows every account's and group's balance since the books began, and picking a period range in the date picker turns it into Net Change for that range (Reset clears the range). Search accounts... filters by number or name and keeps the groups the matches sit in.
  2. Add Group opens the group form: Name, Parent Group, Account Type and, for a group directly under a root, its Class (Asset, Liability, Equity, Revenue or Expense). A group under another group inherits that group's Income/Balance and Class. Add Account opens the account form: Parent Group, Account Number and Name; its Account Type, Income/Balance and Class are shown read-only, because they come from the parent group. A group's row menu (the three dots at the end of the row) also offers Add Group and Add Account under that group, plus Edit Group and Delete; an account's row menu offers Edit and Delete. Only accounts, never groups, receive postings.
  3. To move an account under a different group, open Edit and change its Parent Group. The two root groups cannot be edited or deleted; each refuses with "Root accounts cannot be modified" or "Root accounts cannot be deleted".
  4. Click an account, or its balance, to open its ledger: Opening, Net Change and Closing for the chosen range, then every line that posted to it with Date, Entry, Description, Debit and Credit, 50 lines a page, each entry linking to its journal entry.
  5. To bring balances over from your old books, choose Opening Balances. The balance column becomes an input on every account and the add buttons give way to Cancel and Post; type each account's balance, choose Post, pick the As of date, and confirm. One balanced journal entry is written as of that date, with the difference offset to Retained Earnings, and the page opens it. The button appears only while no opening-balance entry has been posted; Cancel leaves the mode and discards what was typed.

How to tell AimRack which accounts to post to when you configure the company

Default Accounts lists the account every automatic posting uses, in groups: Cash & Banking; Accounts Receivable (Receivables, Prepayments, Customer Write-Off (Bad Debt)); Inventory (Raw Materials, Finished Goods, Work in Progress); Fixed Assets (acquisition cost, cost on disposal, accumulated depreciation and its disposal reversal); Accounts Payable (Payables, Supplier Prepayments, GR/IR Clearing, Vendor Write-Off Income); Taxes (sales, purchase, reverse charge and deferred tax); Equity (Retained Earnings, Currency Translation); Sales & Revenue (Sales, Shipping Revenue, Sales Discounts, Customer Payment Discounts, Realized Exchange Gain); Cost of Goods Sold (plus Indirect Materials & Services and Supplier Payment Discounts); Absorption; Standard Cost Variances (including Inventory Adjustment and Scrap / Cost of Quality); and Operating Expenses (Maintenance Expense, Depreciation Expense, Gain on Disposal, Loss on Disposal, Service Charges, Interest, Rounding Account, Deferred Tax Expense, Realized Exchange Loss). Each slot takes an account of the class shown beside it; Shipping Revenue is required and cannot be the same account as Sales. Set each once and Save; the whole form saves together, so a refused mapping saves nothing. The download button exports the list as a CSV file.

How to set the fiscal year when the company's year does not start in January

Fiscal Year holds Start of Fiscal Year and Start of Tax Year, each a month. The fiscal start month is fixed once any period has been posted to, locked or closed: the field turns read-only and says so, and a changed value is refused with "The fiscal start month can't be changed once accounting periods have been posted to or closed." Delete every open period first if it must change.

How to set payment terms when customers pay on different schedules

Open Payment Terms and Add Payment Term for each schedule you offer. Each has a Name, an After method (Net, End of Month, or Day of Month), the Due Days after that method, the Discount Days after it within which an early-payment discount applies, and the Discount Percent (0 for no discount). The table lists each term's days due, days discount, discount percentage and calculation method; its row menu offers Edit Payment Term and Delete Payment Term. A typical propane company uses Net 15 for households and Net 30 for businesses.

How to open a fiscal year's months when postings need somewhere to go

A month is an accounting period, and a posting belongs to the month of its posting date. Nothing posts into a month until its fiscal year has been generated: the year you are in and the next one are created with the company, and any other year is generated here.

  1. Open Accounting Periods. The page shows one fiscal year at a time, chosen in the Fiscal year picker (every year that has periods, plus the current and next); the heading gives the year's date range and how many of its months are Open, Locked and Closed, and the month containing the company's today is marked Current. Each row shows the month, its close status with what it takes (Open, all postings; Locked, adjustments only; Closed, no postings), its start and end dates, and an actions menu.
  2. Choose Generate Fiscal Year, in the header or in the empty state of a year with no periods yet. The dialog takes the Fiscal year (2000 to 2200, named for the year it ends), previews the twelve months with their dates, marks each Will open or Already exists, and counts both. Generate fiscal year opens the new months for all postings and leaves existing ones exactly as they are, close status included. If the fiscal start month is not set yet, it sends you to Fiscal Year first.

How to close a month when the bookkeeping for it is done

A month moves one way: Open, then Locked, then Closed, and months close in order.

  1. Open the month's Close Period action (click its name, or use the row menu). The dialog lists the close checklist: every required task must be Done or Skipped before the period can close, and a red Cannot close yet notice names what blocks it. The tasks a new company gets, in order: Post pending operational documents; Post or re-date draft journal entries; Lock the period; Post depreciation runs covering the period; Match & eliminate intercompany transactions; Review negative on-hand inventory; Trial balance in balance for the period; Review financial statements; External GL sync complete. The automatic checks run themselves, and each task's information icon explains what it means.
    • Blockers, which must be fixed: documents still waiting to post into the month, draft journal entries dated in it, posted entries whose debits and credits differ, and postings not yet delivered to the connected accounting system (this one passes by itself when none is connected). The first two show a link such as N unposted documents or N draft journal entries that opens the list, each document with its type and status and a link to it.
    • Warnings, which can be skipped: draft depreciation runs ending in the month, and unmatched intercompany transactions.
  2. Choose Lock Period on the Lock the period task. A locked month refuses operational documents dated in it, such as receipts, shipments, invoices and payments, but still takes accounting adjustments such as manual journal entries, depreciation and disposals, so the bookkeeper can adjust while operations move on. Unlock returns it to Open.
  3. Mark the manual tasks done with Mark Done once you have reviewed negative on-hand inventory and the month's balance sheet and income statement. A warning can be skipped with Skip, which asks for a reason; a blocker cannot be skipped.
  4. Choose Close Period. A closed month accepts nothing, and its balances are saved for fast reporting. Its row then offers View Period only: no page reopens a closed month, so lock and review before you close.

Only an empty, open month can be deleted, from the row menu's Delete Period; the dialog says why when it cannot be, and a deletion cannot be undone.

How to slice the numbers when the plain accounts are not enough

  • Dimensions tag each journal line. A dimension has a Name, an Entity Type and an Active switch. The entity type says where its values come from and cannot be changed once created: Custom, where you type the Values yourself, or a list AimRack already keeps: Location, Item, Item Group, Supplier, Supplier Type, Customer, Customer Type, Department, Employee, Asset Class, Cost Center, Work Center, Process or Scrap Reason. The table shows a custom dimension's first values and marks the others Inherited. A branch or bulk plant set up as a location lets you report sales by branch without a separate set of accounts. Deleting a dimension deletes its values too.
  • Cost Centers form a tree, shown as a diagram (Tree View) or an indented list (List View). Each has a Cost Center Name, a Parent Cost Center and an Owner, which becomes required once purchase order approval rules exist. A cost center's menu offers Edit, Add cost center (a child under it) and Delete.
  • Projects are a list with a Project Name and Description. Deleting a project deactivates it and hides it from active lists.
  • Exchange Rates lists every currency with its Code, its Exchange Rate against the base currency, its Source (Base currency, Your rate, Market rate or No rate) and when the rate was last updated. Open a currency to pin your own rate with Save Rate or go back with Reset to market rate, set its Decimal Places and a Historical Rate (Equity) for consolidation, and see the market rate history as a chart or a table with a CSV download. The base currency's rate is always 1 and cannot be overridden.

How to handle trades between two of your companies when you own more than one

Intercompany appears once your company group has more than one company. The table shows each trade's source and target company, amount, description, status and date. A sale from one company to another is recorded automatically when the invoice posts; Add IC Transaction records one by hand with a Source Company, Target Company, Amount (in the source company's currency), Description, Debit Account, Credit Account and Posting Date, which defaults to the source company's today. Run Matching pairs each company's side of the same trade (Unmatched becomes Matched) and reports how many matched. Generate Eliminations writes the entries that remove matched pairs from the consolidated statements (Matched becomes Eliminated), so the money is not counted twice. Regenerate reverses the existing elimination entries and writes them again from the current trades.

How to check that postings reached your accounting system when one is connected

Sync Tie-Out appears once an accounting integration is connected. Each row is one account in one period for one integration: what AimRack posted, what was synced, what is backed by a document, what was excluded, pending or blocked, what the provider holds, and two deltas, internal and external, shown in red when they are not zero. Filter by account or integration. Open a row to see the same amounts and the posted journals behind them, each with its sync status and a link to the entry.

How to reach the ledger's other pages when you need them

  • Journal Entries lists every entry with its date, description and source, status, debits and credits; Add Journal Entry creates a draft and opens it. Writing and posting an entry is in journal entries.
  • Assets lists each fixed asset with its status, class, location, acquisition cost and net book value; Add Fixed Asset creates one as a draft and opens it. Depreciation lists each run; Run Next Period creates a draft run for the next period end over every active asset, and is disabled while a draft run exists. Asset Classes hold each class's depreciation method, useful life, residual value and the seven accounts it posts to, plus tax depreciation when that is enabled. The rest is in fixed assets.
  • Reporting is the list of reports: search it, pin the ones you use to the top, and open saved analysis views. The reports themselves are in reports.

Where this fits

Every operational page feeds the ledger: sales invoices, purchase invoices, payments, credits, receipts and inventory counts. The results are read in Reports, corrected with journal entries, and extended with fixed assets.