How to make a bank transfer in Sage 100

When you need to transfer funds from one account to another in Sage 100—whether it’s to cover payroll, move cash to a sweep account, or for other business reasons—the process can be completed easily within the General Ledger module. If you also use Bank Reconciliation, the transfer is reflected in both modules for seamless recordkeeping.

Below, we outline the step-by-step process to make a bank transfer in Sage 100.

Part 1: transaction journal entry – header tab

Navigate to General Ledger | Main | Transaction Journal Entry.

On the Transaction Journal Entry screen, select the tab labeled “1. Header.”

Image 1. Transaction journal entry header tab in Sage 100

• Source Journal: Enter a code for the bank transfer, such as “BT”. If this is a new source journal, you’ll be prompted to create it. Set the description as desired and set Journal type to “Financial”, then click OK.
• Entry Number: Click the pound sign icon next to the blank field, and Sage 100 will assign the next available entry number.

Part 2: transaction journal format

If you haven’t previously defined a transaction journal format or want to modify it, click “Format.” If already set up, Sage 100 will auto-populate the fields based on your saved settings.

Image 2. Transaction journal format setup in Sage 100

In the Transaction Journal Format screen, fill out the required details as appropriate:

• Offset Account No.: Enter the main GL account number for the transaction type.
• Description: This pulls from Account Maintenance and cannot be edited here.
• Offset: Select the action type (such as “Credit”) for the offset account.
• Transaction Total: Check this box if you want to enter a grand total for the transaction (bank transfer, deposits, withdrawals, etc.).
• Transaction Type: Choose the type (e.g., bank transfer, deposit, withdrawal, check number). For bank transfers, select “Bank Transfer.”
• Auto Increment Check Number: If “check number” is selected, choose whether to auto-increment check numbers.
• Bank Code: Enter the bank code for the account from which funds are sent or for the offset account.
• Transfer Funds to Bank Code: Enter the code for the receiving bank account.

Click “OK” to save your format selections and return to the Transaction Journal Entry screen (“Header” tab).

• Enter the posting date or select it from the calendar icon.
• Enter the transfer number (required). Use your bank-provided transfer/transaction number or a six-digit date (e.g., 121615 for December 16, 2015).
• Verify the source code information.

Part 3: transaction journal entry – lines tab

On the Transaction Journal Entry screen, select the “2. Lines” tab. On line 1, verify information such as Posting Date, Bank Code, and GL Account Number.

• Doc. Refer.: Enter a reference number for the transaction (letters and/or numbers).
• Amount: Enter the dollar amount to transfer.
• Comment: Add any helpful descriptions or notes for your reference.

When you are satisfied with the entries, click “Accept.” Remember to print and update the journal to complete the process.

Next steps

Sage 100 is a powerful accounting solution, but maximizing its efficiency often requires expert guidance. Rand Group’s experienced consultants can help you with Sage 100 setup, process optimization, and training to ensure seamless financial operations. If you want to learn more about Sage 100 or need assistance with your accounting software, contact Rand Group today. Our team is ready to answer your questions and help streamline your financial processes.

Explore additional insights and best practices on Sage and related solutions by visiting our Insights hub.