Journal

Introduction

The Journal is the chronological heart of your bookkeeping. It is the “Book of Original Entry,” where every business transaction is recorded exactly as it occurs.

The Golden Rules of Journaling

  • Chronology: Entries are recorded in order of date. This creates a permanent, searchable history of your business activity.
  • The Double-Entry Principle: Every transaction affects at least two accounts (a Debit and a Credit). Abaque simplifies this by automatically identifying the correct accounting behavior when you select an account from the dropdown menu.
  • Balance: The fundamental accounting equation (Assets = Liabilities + Equity) must always stay in balance. The Journal interface is designed to ensure that your entries are mathematically sound before they flow into your financial reports.

The goal of the Journal is to transform raw data into GIFI-mapped information, ensuring that your financial reporting is automated and accurate.

Linking Voucher Documents

To maintain a professional audit trail, it is recommended to store all digital vouchers—such as invoices, receipts, and credit notes—on Google Drive. For paper-based documents, we recommend scanning them into a digital format as soon as possible to ensure your records are both permanent and easily accessible. By linking these documents directly to your Journal entries, you ensure that every transaction is one click away from its supporting evidence.

For sales and purchase transactions, the recommended labeling format in the ITEM column is:

<client/supplier> <invoice #>

Interactive Example: In the ITEM column, you would enter: “NovaSphere 6”

(Click the blue 6 above to see the linked voucher document in action.)

New to linking? Learn how to add links to your spreadsheet.

Using this consistent naming convention creates a searchable link between your financial data and your stored document archives, simplifying future audits or internal reviews.

Planning Future Transactions

In Abaque, you can plan upcoming transactions—such as future sales, purchases, or scheduled payments—without affecting your current external balances. This allows you to perform your daily balance checkup against your actual bank statements without interference from future events.

The Staging Workflow

To “stage” a future transaction, leave the DATE column (Col A) blank and record the expected date in the REMARKS column. To ensure the amount only impacts your ledger once a date is entered in Col A, use the following formula in the amount column:

=IF(ISBLANK(INDIRECT("A" & ROW())), 0, <Transaction Amount>)

By using this staging formula, you can treat your Journal as a real-time forecasting tool, ensuring your future financial obligations are documented and visible without distorting your current financial position.

Visual Status Indicators

The Journal uses intelligent conditional formatting within the ITEM column to provide an immediate overview of your outstanding accounts. This visual feedback ensures that no receivable or payable is overlooked during daily data entry—an essential feature for maintaining healthy cash flow for an accrual accounting system.

Automated Highlighting Logic

  • Green Background (Accounts Receivable): Triggered by 1060 | 1100 | Accounts Receivable. The cell remains green until a matching “Debit -” entry is recorded.
  • Pink Background (Accounts Payable): Triggered by 2621 | 2100 | Accounts Payable. The cell remains pink until a matching “Credit -” entry is recorded.
The Matching Rule (Clearing a Highlight)

The Debit and Credit prefixes represent the final outcome a payment will have on your short-term assets (such as bank accounts). To clear a highlight once a transaction is fully settled, the ITEM name for the payment entry must match the required prefix followed by the original item name.

Pro-Tip: To avoid typos, reference the original cell directly. For example, if your original invoice is in cell B7, enter the following in your payment row:

="Debit - " & $B$7
Tracking Multi-Part Settlements

If you are issuing or receiving multiple payments for a single invoice, you can track each stage using a modified prefix (e.g., Debit(1) - or Credit(Jan) - ). Because the formula looks for an exact match of the standard prefix, the original entry remains highlighted as “Outstanding” until the final settlement is recorded using the standard "Debit - " or "Credit - " string.

By using these indicators, you can treat your Journal as a real-time task list, ensuring your financial obligations are always visible until they are fully settled.

Journal Anatomy

Every row in the Journal represents a specific transaction. While the sheet includes columns for your own tracking (like DATE and REMARKS), the Abaque calculation engine specifically expects a data range that begins with the DEBIT column. The number of columns following the AMOUNT must be adjusted based on your regional tax settings and match the expectation of the second parameter of the GIFI_21_BALANCE function called from the CoA.

Col Name Engine Mapping Description
A DATE — The transaction date. Leave blank to “stage” a row.
B ITEM — Drives Visual Status Indicators. Not used in financial totals.
C DEBIT [1] Debit Dropdown selection. The add-on maps the account number to the correct GIFI code.
D CREDIT [2] Credit Dropdown selection. The script maps the account number to the correct GIFI code.
E AMOUNT [3] Amount The net transaction amount before taxes.
F+ Tax Columns [4+] Tax Logic Zero or more columns (e.g., STAX-GST/HST, PST, STJUR-PROV) depending on your regional configuration.
TOTAL — Represents the final sum of the row. This column is only necessary when sales taxes are involved to compute the total transaction value using the SUM formula.
REMARKS — Internal notes or scheduled dates for pending transactions.

Total Flexibility

Beyond the specific sequence required by the GIFI_21_BALANCE function, Abaque imposes no constraints on your Journal layout. You are free to insert additional columns to suit your workflow—such as dedicated dropdowns for Client/Supplier lists, Invoice Numbers, or Project IDs—provided the core functional columns remain in their relative order.

Transaction Grouping & Vouchers

As your Journal grows, you can use the native Google Sheets Row Grouping feature to maintain a clean and organized workspace. This is particularly useful for grouping multiple rows that belong to a single complex voucher.

To group transactions:

  1. Select the rows representing a single transaction, starting with the second one.
  2. Right-click the selected row numbers and choose View more row actions > Group rows.
  3. Use the [ + ] or [ − ] buttons in the left sidebar to collapse or expand these entries.
Pro Tip

The same DATE and ITEM values can be shared across grouped rows by referencing the content of the first row (e.g., =$A$14). This ensures consistency within the voucher.

Note: Grouping rows is a visual organization tool and does not affect the GIFI_21_BALANCE calculation. The Abaque engine will continue to process all data within your defined range, regardless of whether the rows are expanded or collapsed.

Continuous Reconciliation

The integrity of your financial reporting in Abaque depends on the practice of continuous reconciliation. Unlike traditional systems that encourage periodic bank reconciliations (e.g., once a month), Abaque is designed for real-time accuracy.

The Real-Time Verification Rule

Whenever you record a transaction in the Journal that impacts a short-term asset or liability account—such as a bank account or a credit card—you must immediately verify the resulting balance against your external financial portal. This ensures that every entry in your ledger is a faithful reflection of your actual cash position.

The Journaling Checklist

To maintain your system's integrity, follow these three steps for every entry involving a bank or credit card account:

  1. Enter: Record the transaction details in the Journal.
  2. Compare: Open your bank or credit card portal and check the “Current Balance”.
  3. Confirm: Verify that the Abaque calculated balance matches the external balance exactly.
Compliance & Accuracy

As outlined in the Abaque Terms of Service (Section 9), accuracy requires you to monitor and reconcile account balances continuously as transactions are added. The system relies on this real-time verification to prevent the accumulation of errors or imbalances that could distort your year-end financial statements.

By maintaining this habit, you transform your Journal from a simple record of the past into a high-precision tool for current financial management. This discipline allows you to perform daily balance checkups with total confidence, knowing that your internal records and external account balances are always in perfect sync.