Tag Archives: journal

Import journals into accounting software

Software: MoneyWorks accounting software

You need to have type, date, reference, account, description, and amount field in the spreadsheet when preparing an import file for journal transaction.

For journal transaction, use “Jn” for type field. You can either have the type field in the spreadsheet or preset it in the import MAP. The Date is the date of the journal transaction, which you can either have it in the import file or set it in the import MAP as the date of import.

The account field captured the account code, which has to be the same code you used in MoneyWorks. You do not need to have the account name as it will pick up from the system automatically. The journal memo map to the description field of the detail line and the amount field contains both debit and credit value (with a negative for credit).

Import Journal into accounting software

Import the file from the File menu once you have prepared the spreadsheet. Alternatively, you can save the import MAP if you require to import frequently.

Besides importing journals, you can also import transaction such as Invoices, order, payment or receipt transactions. MoneyWorks is a powerful system which helps an accountant ease the daily accounting task. Book a demo today to find out more about how MoneyWorks helps in managing your business finance.

The Create Journal

Software: MoneyWorks accounting software

Create Journal is a stock related journal in MoneyWorks accounting system, which uses to increase the stock quantity such as manufactured or the existing product. For example, you discovered that Product_123 has ten pieces instead of nine, you may use a Create Journal to increase the stock on hand of Product_123 instead of a full stocktake process. Use a relevant Cost of Sales or Expense account as a contra account if you are using a Create Journal instead of inventory assembly feature to increase the stock on hand of the manufactured product.

Create journal

Change the contra account to SETUP if you are using the Create Journal instead of a stocktake to record the ‘opening stock’. The SETUP account is an account used in MoneyWorks to store all the opening balances of your file.

MoneyWorks is a powerful accounting system at an affordable price. Download a trial to test drive or sign up a free demo to find out how MoneyWorks works for your business.