GeminiPOS
Complete Bookkeeping & General Ledger Module
Built-in double-entry accounting: auto journal entries from sales, Accounts Receivable tracking, P&L, and Balance Sheet.
Complete Bookkeeping & General Ledger Module
The Finance module in mystore (web) brings sales, customer debts, supplier bills, journals and financial reports into one place. Sales from the GeminiPOS POS are posted to the journal automatically by the POS when the sale is saved, so the reports fill without manual input.
Before You Start
- Growth or Pro plan, with the Accounting & expenses module turned on.
- An account with the accounting:view permission (Owner/Admin always have it).
- POS sales must already be synced to the server.
Step 1: Open Finance
Overview shows this month's Profit & Loss, outstanding customer and supplier debts, the number of journals, shortcut buttons, and a Setup Checklist (Chart of Accounts and Accounting Periods).
- Log in to mystore.
- In the side menu, tap Finance. You land on Overview.
- The tab bar at the top has groups:
- Overview
- Cash Flow: Get Paid, Pay Bills, Expenses
- Books: Accounting, Reports
- Compliance: Compliance, E-Invoice (Malaysia)
- In each section, choose a tab below it. Tap the date range to change the period; the store picker at the top filters by branch. For Sales, P&L, Cash Flow and Tax you can choose a Daily or Monthly view.
Step 2: Get Paid
- Sales — Sales, Cost, Profit, #Tx and Average for each day/month, with Total Sales, Total Transactions, Avg Ticket
- AR — Customer debts: Total AR, Aging Summary (Current, 31-60, 61-90, 91-120, >120 days) and Customer List with Credit Limit (red when over the limit)
- Top Items — Top 20 products, sorted by Revenue, Quantity or Profit
Step 3: Pay Bills
Add a recurring expense: The list shows the next date and marks items Overdue. No reminders are sent — check this tab yourself.
- AP — Debts to suppliers: Total AP, Aging Summary and Supplier List
- Tax — Total Sales, Taxable Sales, Exempt Sales, Tax Collected, Purchase Tax, Net Tax Payable and the effective tax rate
- Budget — Total Budget, Total Actual, Variance and a category breakdown; a warning when categories are over budget. Monthly budgets are set in Expenses → Categories.
- Recurring — List of recurring expenses (rent, utilities)
- In the Recurring tab, tap Add Recurring Expense.
- Fill in Description, Amount, Frequency (Daily / Weekly / Monthly) and Next Date.
- Tap Save.
Journal — manual entries
Use this for transactions that do not go through the POS (e.g. paying rent by bank transfer). The journal list can be exported to Excel.
- Journal tab → tap New Journal.
- Choose the date and fill in Description (required).
- Under Journal Lines, choose an account and fill in Debit or Credit. Tap Add Line for more lines.
- Make sure Total Debit = Total Credit — an unbalanced journal cannot be saved.
- Tap Save Journal.
Other tabs
Depreciation example: A RM 3,000 fridge, salvage value RM 0, 5-year life → RM 50 per month (RM 600 per year).
- Settlement — Match marketplace and payment gateway payout statements: Sync API Statements or Upload Statement (CSV), then Generate Settlement Journal
- Accounts — Chart of accounts: Add Account (Code, Name, Type, Sub-type), edit, or deactivate accounts
- Periods — Close a period (unposted journals are posted), Reopen, or Lock — a locked period cannot be reopened
- Bank — Transactions by status (Pending / Matched / Cleared) — Mark Matched, Mark Cleared, fill in Statement Ref. Auto Match: paste bank statement lines in the format date,description,amount (one line per transaction) and tap Run Auto Match
- Ledger — Choose General, Customer or Vendor, search a name, and see every transaction with Opening Balance and Closing Balance
- Assets — Add Fixed Asset: Asset Name, Cost, Purchase Date, Useful Life (Years), Salvage Value. Straight-line depreciation is shown: (Cost − Salvage Value) ÷ (years × 12) per month
- Audit — Log of accounting activity with search and related journal details
- Rates — Store currency exchange rates (From, To, Rate, Date)
Step 5: Reports
The Balance Sheet and Trial Balance show balances as of today, not for a date range.
- P&L — Revenue, COGS, Gross Profit, Expenses, Refunds, Net Profit, with a daily/monthly breakdown — Share as PDF, Share as Excel
- Balance Sheet — Assets, Liabilities, Equity and a Balanced / Unbalanced check — PDF, Excel
- Trial Balance — Debit and Credit for each account with a Balanced / Unbalanced check — PDF, Excel
- Cash Flow — Opening Cash, Operating / Investing / Financing Activities, Net Cash Flow, Closing Cash — —
- Cash Balance — Cash Balance by Store (Cash and Bank) — —
- Inventory — Total Inventory Value, Total Items, Value by Category — —
Step 6: Compliance
The Compliance section has the Tax tab (the same sales tax report), Zakat and Tax Filing. See Business Zakat Calculator & Income Tax Helper.
Frequently Asked Questions
Finance menu does not appear
Check the plan (Growth/Pro), the Accounting & expenses module, and the accounting:view permission.
Reports are empty
Check the date range and store picker; make sure POS sales have synced.
Balance Sheet is Unbalanced
Check the Trial Balance and recent manual journals.