Solution Properties
Solution ID:
250114153152263
Last Modified Date:
Wed Jan 15 11:05:21 UTC 2025
Taxonomy Path:
Case category//How do I...//setup/create/run a report
Author:
[email protected]
Import the salary journal report
Description

Once you have generated and exported the Salary Journal Report, you can import it into you accounting program.

This creates salary journals to your selected nominal codes.

This will save you time and reduce processing errors. 

 CAUTION: This article will guide you through importing into Sage 50 Accounts only. If you use a different program, you must refer to your provider. 

Cause
Resolution

By default, Sage 50 Accounts use T9 as the non-vatable tax code. If you’ve changed this, you must manually edit the export file. Replace T9 with the tax code you’re using.

To check the non-vatable tax code in Sage 50 Accounts:

  1. Select Settings.
  2. Select Company preferences then select the VAT tab.

To import into Sage 50 Accounts

▼Steps
  1. In Sage 50 Accounts, select File, then Import.
  2. At this point, we recommend you take a backup, then select Next.
  3. In the Data type window, select Audit Trail transactions, then select Next.
  4. In the Data source window, select Comma-separated (*.csv). Select the First row contains headings check box, then Next.
  5. Select Browse to locate and choose the file to import. Select Open, then Next.
  6. Complete the Imported Field column as required. Choose the relevant field from the drop-down list. Compulsory fields have an asterisk.
  7. If required, you can use the Load Map option to use the default Sage 50 Accounts field mapping or a saved mapping. Once you've mapped the required fields, select Next.

Check the summary information is correct, then select Import or Finish.

If successful, a list of transactions imported appears in the Record Imported pane. Select Close.

 NOTE: If the Data Import wizard validation identifies any data issues, nothing imports. A message appears to explain where in your file the issue is.

You can edit the data in your import file to correct the issue. Then close the file, and run the Data Import wizard again. 

Bank Payments

Once the journals appear in your accounts, you need to deal with the affect this will have on your bank balance. You do this by creating Bank Payments. These show you've paid your employees and HMRC and will keep your bank balance accurate.

▼Steps

To do this in Sage 50 Accounts:

  1. Select Bank accounts.

  2. Select the Payments drop-down, then Bank payment. Fill in as required.

     

    Example 

     

    Bank Date Nominal code Details Net Tax code Tax
    Bank Nominal code Transaction date Net wages 2220 Wages Net wages value T9 0.00

  3. Select Save then Close.

  4. Enter the relevant details on the Bank Payments window.

    These bank payments should always use the non-vatable tax code, which is T9 by default. This ensures they don't appear on your VAT Return.

  5. Create more bank payments as required. PAYE, NI, attachments, pensions and student loans etc.

Steps to duplicate
Related Solutions