Journal Entries in Ratals ERP: Complete Accounting Guide

Rob Cuppett Author: Rob Cuppett

Introduction: Why Journal Entries Matter

Journal entries are the foundation of every accounting system. They are the first step in recording financial transactions, ensuring accuracy, transparency, and compliance. Each entry captures the debit and credit movements that keep your books balanced.

Below is a screenshot of the main Journal Entries dashboard in Ratals ERP, showing two sample entries to give you a clear visual of how it appears:

Journal Entries dashboard showing sample entries

In Ratals ERP, journal entries are even more powerful because they are connected to your entire accounting workflow. Whether a customer checks out online, you're processing an order, paying a vendor, or posting a purchase order, the system automatically creates journal entries in real time. These entries then flow into reports like the general ledger, trial balance, balance sheet, income statement, and cash flow statement.

This guide will walk you through everything you need to know about managing journal entries in Ratals ERP, including:

  1. What Is a Journal Entry?
  2. Accessing Journal Entries in Ratals ERP
  3. Searching Journal Entries
  4. Understanding Journal Entry Details
  5. Editing vs. Adjusting Journal Entries
  6. The Double-Entry Rule in Ratals ERP
  7. Linking Journal Entries to Other Records
  8. Automated Journal Entries
  9. When to Create Manual Journal Entries
  10. How to Manually Add a Journal Entry in Ratals ERP
  11. Real-Time Reporting Benefits
  12. Best Practices for Managing Journal Entries
  13. Conclusion: Journal Entries as the Core of Your Accounting
  14. Frequently Asked Questions (FAQs)

By the end, you'll not only understand how journal entries work in Ratals ERP but also know how to use them to keep your accounting accurate and audit-ready.

What Is a Journal Entry?

A journal entry is a record of a financial transaction. It includes:

  • The date of the transaction
  • The accounts affected
  • The debit (DR) and credit (CR) amounts
  • Any linked references (such as order ID, vendor ID, or customer ID)

Ratals ERP uses a double-entry system, which means every debit must have a corresponding credit. This ensures your books always balance. For example:

  • If you record an order payment from a customer, Cash increases (Debit) and Accounts Receivable decreases (Credit).
  • If you pay a vendor bill, Accounts Payable decreases (Debit) and Cash decreases (Credit).

Without journal entries, financial reports like the trial balance or balance sheet couldn't exist.

Accessing Journal Entries in Ratals ERP

You can access all journal entries by navigating to:

Admin > Accounting > Bookkeeping > All Journal Entries

On this page, you'll see a list of all journal entries, starting with the most recent. Each entry contains two or more rows (debit and credit), showing the specific accounts that were affected.

Searching Journal Entries

As your business grows, you'll need to quickly locate specific journal entries. Ratals ERP provides powerful search and filter options to make this easy. Here's a screenshot showing how you can search for entries:

Journal Entries dashboard with search and filter options

Available Search Fields

You can filter by:

  • Date Range (From / To)
  • Journal Number
  • Order ID
  • Purchase Order ID (PO ID)
  • Bill ID
  • Vendor ID
  • Customer ID
  • Inventory ID
  • Inventory Asset ID
  • Original Journal Entry ID

Practical Example

  • Searching for a Customer ID will show all journal entries tied to that customer.
  • Searching for an Order ID will display every entry related to that specific order.

This makes it easy to track down related entries during audits, reconciliations, or customer/vendor inquiries.

Understanding Journal Entry Details

Each journal entry includes multiple columns of data. The main columns are:

  • Posted to Account Name
  • Posted to Account #
  • Debit (DR)
  • Credit (CR)

Like so:

Adding Journal Entry rows

At the bottom of each entry, Ratals ERP displays totals for both debits and credits. These must match before the system allows the entry to be saved.

Editing vs. Adjusting Journal Entries

Ratals ERP gives you the option to edit journal entries, but it's important to use this feature wisely.

When Editing an Existing Entry May Be Okay:

  • If you just created the entry and noticed a typo or small mistake
  • If no one else has used the entry in reporting yet
  • Entries cannot be edited if the accounting period for the entry date has been locked

Why Adjustments Are Better

For most cases, it's better to create a new adjustment entry instead of editing. Adjustments allow you to:

  • Maintain an audit trail
  • Clearly see before and after values
  • Track why changes were made

Editing an existing entry, by contrast, leaves no record of why it was changed. That can confuse other team members or auditors reviewing your books later.

Best Practice: Use editing only for immediate corrections. Use adjustments for everything else.

The Double-Entry Rule in Ratals ERP

Ratals ERP enforces the double-entry principle. Every transaction must have at least one debit and one credit, and the totals must balance.

If your entry is off by even one cent, the system won't let you save until it's corrected. This ensures financial integrity across all accounts.

Linking Journal Entries to Other Records

One of the biggest strengths of Ratals ERP is how journal entries connect to other parts of the system.

When creating an entry manually, you should always link it to the right IDs:

  • Order ID
  • Customer ID
  • Vendor ID
  • Purchase Order ID
  • Bill ID
  • Inventory ID
  • Inventory Asset ID

This linking ensures that when you later search or run reports, all related entries show up.

For example: If you manually create an entry for a customer order but forget to include the Order ID, that entry won't appear in future order-based searches.

Automated Journal Entries

One of the biggest time-savers in Ratals ERP is automation. Many journal entries are created automatically as you perform normal business operations. It's important to know whether an entry was created manually by a user or automatically by the system. To make this clear, all automated entries are labeled with "System Created" as the "Creator" or "By". If a logged-in admin user creates a journal entry manually, the entry will display that user's name instead of "System Created." like this:

Journal Entry manually created by an admin user

This labeling makes it easy to quickly identify whether a journal entry was created manually by a person or automatically by the system as a result of an action performed within the software.

Examples of Automated Entries

  • When an order is placed
  • When an order is shipped
  • When a bill is entered or paid
  • When a customer invoice payment is received
  • When purchase order items are received
  • When a purchase order is posted
  • When a vendor is paid

Why This Matters

Automated entries mean you don't need to manually record every transaction. Instead, the system ensures consistent and accurate accounting while you focus on running your business.

When to Create Manual Journal Entries

Even with automation, there are times when you'll need to create journal entries yourself. Common cases include:

  • Adjustments (fixing previous entries)
  • Owner withdrawals or contributions
  • Transitioning to Ratals ERP and transferring final balances from a previous system

These are higher-level transactions that typically don't happen through standard admin pages.

How to Manually Add a Journal Entry in Ratals ERP

You can manually add a journal entry by navigating to:

Admin > Accounting > Bookkeeping > Add Journal Entries

Before adding a journal entry, consider whether it should be linked to another record, such as a customer, order, or vendor. Make sure you have the relevant IDs on hand so you can connect them in the entry. Once you have these IDs from the admin system, you can begin creating the manual entry. The entry page looks like this:

Manually adding a Journal Entry

Step 1: Fill in Entry Details

When creating a new entry, fill in the following fields that apply:

  • Journal Date
  • Entry Type
  • Journal Number
  • Order ID
  • Purchase Order ID
  • Bill ID
  • Vendor ID
  • Customer ID
  • Inventory ID
  • Inventory Asset ID

Step 2: Add Row Details

For each row, include:

  • Post to Account
  • Debit (DR)
  • Credit (CR)
  • Narration (description of the row)

Ratals ERP also provides a reference diagram with arrows that show how money flows based on the account type, as seen in the screenshot above. This helps you confirm whether to use a debit or a credit.

Step 3: Save the Entry

Once the correct accounts are selected and the debits and credits are balanced, click Save. If they are not balanced, the system will block the save and prompt you to make corrections.

Real-Time Reporting Benefits

One of the most powerful features of Ratals ERP is real-time reporting.

As soon as you create or adjust a journal entry:

  • It appears in the General Ledger
  • It updates the Trial Balance
  • It flows into financial statements (Balance Sheet, Income Statement, Cash Flow)

If this is the first entry for an account, that account will immediately begin showing in your reports.

This means you don't have to wait for batch updates or manual reconciliations - your reports are always up to date.

Best Practices for Managing Journal Entries

  • Always link IDs (order, vendor, customer, etc.) to keep records connected
  • Use adjustments instead of edits to maintain a clear audit trail
  • Review automatic entries (By: System Created) regularly to ensure accuracy
  • Double-check debits and credits before saving
  • Document narrations clearly so future users understand the purpose of the entry

Conclusion: Journal Entries as the Core of Your Accounting

Journal entries are at the heart of Ratals ERP's accounting system. They power every report, from the general ledger to the financial statements.

By mastering journal entries, you'll:

  • Ensure accurate and reliable reporting
  • Save time with automation
  • Maintain audit-ready records
  • Confidently manage both daily and complex accounting tasks

Now that you understand how journal entries work in Ratals ERP, the next step is to create your first manual entry. This will give you hands-on experience and prepare you for managing adjustments, closings, and other higher-level tasks.

Frequently Asked Questions (FAQs)

What is a journal entry in Ratals ERP?

A journal entry is a financial record that tracks debits and credits across accounts. In Ratals ERP, journal entries can also be linked to orders, vendors, and customers for full traceability.

Can journal entries be edited?

Journal entries can only be edited if the accounting period is not locked. For most corrections, it is recommended to create an adjustment entry instead of modifying an existing one.

When are journal entries created automatically?

In Ratals ERP, journal entries are automatically created when you place or ship an order, record a bill or payment, receive or post a purchase order, or receive invoice payments.

When should I manually create a journal entry?

Manual journal entries are typically required when transitioning to Ratals ERP, making adjustments, recording owner withdrawals or contributions, or handling unique transactions outside normal workflows.

Rob Cuppett
About the Author
Rob Cuppett is the founder and lead engineer behind Ratals, bringing over 20 years of experience in digital marketing, software development, and business automation. He shares expert tutorials, practical guides, and insights to help business owners optimize, customize, and fully leverage software solutions to grow their businesses efficiently.
0 Comments
Post a New Comment
This site uses cookies to deliver its services and to analyze traffic. Learn more on our Cookie Policy and Privacy Policy.