Import journal entries from CSV file in Sage 500

By | February 24, 2017

In standard MAS 500, journal entry transaction is created for passing the account to account entries to match the general ledger balance. There must be two lines entry-level (debit and credit). The totals of the debit and credit for any transaction must always equal to each transaction so that an account transaction balance always perfect and match.

Multiple companies may use the larger number of journal entries in every day in order to balance the General ledger accounts. If the client has to create a large number of journal entries, it would be a time-consuming task.

New Stuff: Item Types in Inventory Management in Sage 500

In order to ease the process of creating journal entries, we have created a utility which shall import journal entries from data files such as CSV etc.

The data file should contain all the required fields regarding the journal entry i.e. Account no, amount

CSV File records: GL Account no, amount

For example:

00000000SW,-85.10
1010000000,-150.30
1020000000,-85.00
45001000SE,-150.40

  1. If the data file contains the amount in positive means import utility will consider it is the debit amount.
  2. If the data file contains the amount in negative means import utility will consider it is the credit amount.

Process journal transaction

The user will need to generate a new batch number, set the Posting Date, and leave Entry Type as Standard. Then the user will click the browse button to select the file to be imported and click to Import GL transaction button to generate a new journal entry.

This way a user can import a larger number of the journal voucher entry into the MAS 500 by using data file.

Refer the below-mentioned screenshot which is auto-imported journal voucher entry.

Enter journal transaction

If you feel you could be benefited from this utility or for any other form of customizations feel to contact us at accpac@greytrix.com.

About Us
Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique integration solutions for Sage CRM with Sage ERP’s (Sage X3Sage 100Sage 500 and Sage 300).We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migrating to Sage CRM from ACTGoldmine and other CRM’s.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.