Sage Accounts - CSV upload

BrightPay's payroll journal feature allows users to create wages journals from the finalised payslips and export to CSV for upload into Sage accounting software.


1) Within Payroll, select Journal on the menu toolbar, followed by Sage:

 

 

2a) On the next screen, choose Sage Accounts (CSV File) as your destination.

 

b) Set your Date Range - the journal will include records for all payslips (across all pay frequencies) with a pay date within the selected range. 

 

c) Roll up - select whether you would like the journal to include individual records for each employee or whether to merge the records for each unique date.


 

d) Click Continue

 

3a) Nominal Ledger Mapping - the default nominal ledger code mappings which specifically relate to Sage will already be entered for the user. 

If desired, these can be edited, should the user wish to map to different nominal accounts that exist within Sage. A nominal account code can be used for multiple items.

 


b) When ready to proceed, click 'Continue'

 

 

4) Nominal Ledger Mapping - Variations - this screen allows you to specify any circumstances for which amounts should be mapped to an alternate nominal account code (e.g. depending on period type, directorship, departments, specific rates/additions/deductions, etc.)

a) For each payroll data item you wish to add a variation for, click Add Variation:






b) For the payroll data item selected, set the rules to apply in order for the amount to be mapped to the designated nominal account you enter on this screen.

Rules can be set according to period type, directorship, department and specific pay items.


Example

You wish the salaries of all directors within the Accounting department to be mapped to the Director's Remuneration nominal account within your accounting software. Your rules may thus be set as follows:



 

 c) Click Save when complete.

 

Your rule will now be displayed on screen under the payroll data item it is associated with.

 

d) Further variations can be added for different pay items or for the same payroll data item by simply clicking Add Variation again and setting the rules to apply.

e) Once variations have been set, these can be edited, deleted or re-ordered by clicking the spanner symbol next to it. In addition, clicking the nominal account information displayed in green provides quick access to the rules that have been set for it.




 

f) On completion of this screen (where required), click 'Continue'.

 

Your journal will now be displayed on screen for review. Simply click the 'Back' button to make any amendments. 


5a) When ready to export the journal to CSV, click the 'Export Sage CSV File...' 

 



b) Browse to the location where you would like to save your CSV file to, then click 'Save'.

c) Press 'Print' to print,email or export a copy of your journal to PDF.

d) To close the journal screen, simply click the cross at the top right of this screen. If you have made any changes to the journal, you will be asked if you wish to save your changes. Click 'Yes' or 'No' as required.


Your payroll journal is now ready for upload into your Sage accounting software.

 

 

Need help? Support is available at 0345 9390019 or support@brightpay.co.uk.

Important Information for Mac UsersBureau Enhancements - Additional Functionality Bureau Licence Holders (Only)Installing BrightPayOrdering for The New Tax YearImporting From The Previous Tax YearMoving to BrightPay from another payroll softwareEmployer DetailsEmployee DetailsCoding NoticesProcessing PayrollImporting Pay Data using CSV FilePayroll CalendarPayslip TranslationsMaking Corrections to PayrollPre-paying an EmployeeScheduling Future PaymentsSwitching an Employee's Pay FrequencyRTICommon HMRC Error MessagesHMRC PaymentsAnalysisGender Pay Gap ReportingPayroll JournalsStartersLeaversStudent Loan DeductionsPostgraduate Loan DeductionsStatutory PaymentsPensions (outside of Automatic Enrolment)Attachment of EarningsExpenses & BenefitsPayroll GivingDirectorsEmployee CalendarEmployer CalendarHolidaysRates & Thresholds at a GlanceTaxScottish Rate of Income TaxWelsh Rate of Income TaxNational InsuranceEmployment AllowanceApprenticeship LevyNational Minimum/Living WageOff-Payroll Working in the Public SectorMileage Allowance Payments (MAPs)Year EndBacking Up/Restoring Your PayrollBrightPay Licence Terms and ConditionsConstruction Industry Scheme (CIS)Automatic EnrolmentBrightPay ConnectGDPR