Welcome
Guest
, you are in:
<root>
•
Login
Showbiz Help
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Back
Exporting Accounts to Sage
Modified on 06/01/2016 12:24 PM
by
Suzanne Coy
Categorized as
Accounts and Orders
,
Sage Accounts Software
__'''INTRODUCTION'''__ This document explains the transactions that are created in the Sage Import file from the various Showbiz transaction types. The following table explains the transactions created in Showbiz and their counterparts created in the Sage Import file: @@@@<table width="1013" height="192" border="1" cellpadding="1" cellspacing="1"> <tr> <th width="349" align="left" scope="col">Showbiz Transaction</th> <th width="351" align="left" scope="col">Export File countrtpart(s)</th> <th width="295" align="left" scope="col">Notes</th> </tr> <tr> <th align="left" scope="row">Invoice (INV)</th> <td>Sales Invoice (SI)</td> <td> </td> </tr> <tr> <th align="left" scope="row">Receipt (REC)</th> <td>Sales Actual (SA)</td> <td> </td> </tr> <tr> <th align="left" scope="row">Credit Note (CRN)</th> <td>Sales Credit (SC)</td> <td> </td> </tr> <tr> <th align="left" scope="row">Refund (REF)</th> <td><p>Sales Invoice (SI)</p> Bank Payment (BP)</td> <td>Two Sage transactions are created for the refund. The sales invoice (SI) created is quite different to a standard sales invoice generated from a Showbiz Invoice (INV).</td> </tr> <tr> <th align="left" scope="row">Overpayment (OVP)</th> <td>Sales Credit (SC)</td> <td>Basically works in the same way as a credit note</td> </tr> <tr> <th align="left" scope="row">Repayment (REP)</th> <td><p>Sales Invoice (SI)</p> Bank Payment (BP)</td> <td>Basically works in the same way as a refund</td> </tr> </table> Also see: [http://help.strident.co.uk/showbiz/Entering-Transactions-To-Balance-Accounts.ashx] __'''GENERAL TERMS'''__ • '''Cus Acc''' = Customer Account (should use generic Showbiz Customer Account Reference) set up in the General Accounts Info utility. • '''Rec Acc''' = Standard Receipt Account set up in the General Accounts Info utility. • '''Prz Acc''' = Standard Prize Account (often the same as the Standard Receipt Account) set up in the General Accounts Info utility. • '''NC''' = Nominal Code. • '''Curr''' = Currency field. Version 12 and lower of Sage 50 required default value of 1 for GBP. • '''Miss''' = Miss Posting Acount. The following are explanations of the transactions created in the Sage Import file from the relevant Showbiz transactions: __'''INVOICE TRANSACTION'''__ '''General''' <table width="1014" height="57" border="1" cellpadding="1" cellspacing="1"> <tr> <th scope="col">SI</th> <th scope="col">Cust Acc</th> <th scope="col">NC</th> <th scope="col">Dept</th> <th scope="col">Date</th> <th scope="col">Ref</th> <th scope="col">Details</th> <th scope="col">Unit Amt</th> <th scope="col">VAT Code</th> <th scope="col">VAT Amt</th> <th scope="col">Curr</th> <th scope="col">User</th> </tr> </table> '''Prize''' N/A __'''RECEIPT TRANSACTION'''__ '''General''' <table width="1014" height="57" border="1" cellpadding="1" cellspacing="1"> <tr> <th scope="col">SA</th> <th scope="col">Cust Acc</th> <th scope="col">Rec Acc</th> <th scope="col">Dept</th> <th scope="col">Date</th> <th scope="col">Ref</th> <th scope="col">Details</th> <th scope="col">Unit Amt</th> <th scope="col">VAT Code</th> <th scope="col">VAT Amt</th> <th scope="col">Curr</th> <th scope="col">User</th> </tr> </table> '''Prize''' N/A __'''CREDIT NOTE TRANSACTION'''__ '''General''' <table width="1014" height="57" border="1" cellpadding="1" cellspacing="1" <tr> <th scope="col">SC</th> <th scope="col">Cust Acc</th> <th scope="col">NC</th> <th scope="col">Dept</th> <th scope="col">Date</th> <th scope="col">Ref</th> <th scope="col">Details</th> <th scope="col">Unit Amt</th> <th scope="col">VAT Code</th> <th scope="col">VAT Amt</th> <th scope="col">Curr</th> <th scope="col">User</th> </tr> </table> Cus Acc, NC and Dept the same as the ‘parent’ invoice. '''Prize''' <table width="1014" height="57" border="1" cellpadding="1" cellspacing="1"> <tr> <th scope="col">SC</th> <th scope="col">Cust Acc</th> <th scope="col">Prz Acc</th> <th scope="col">Dept</th> <th scope="col">Date</th> <th scope="col">Ref</th> <th scope="col">Details</th> <th scope="col">Unit Amt (Full Amt)</th> <th scope="col">VAT Code(T0)</th> <th scope="col">VAT Amt(0)</th> <th scope="col">Curr</th> <th scope="col">User</th> </tr> </table> Dept (Department) obtained from Stock Item or if that is absent, then taken from general Prize Department set up in the General Accounts Info utility. NB. For prize transactions - Details = Prize Chq. No. – X. __'''REFUND TRANSACTION'''__ '''General''' <table width="1014" height="71" border="1" cellpadding="1" cellspacing="1"> <tr> <th scope="row"><table width="1162" height="71" border="1" cellpadding="1" cellspacing="1"> <tr> <th scope="col">SI</th> <th scope="col">Cus Acc</th> <th scope="col">Miss</th> <th scope="col">Dept</th> <th scope="col">Date</th> <th scope="col">Ref</th> <th scope="col">Details</th> <th scope="col">Unit Amnt</th> <th scope="col">T9</th> <th scope="col">0</th> <th scope="col">Curr</th> <th scope="col">User</th> </tr> <tr> <th scope="row">BP</th> <td align="center"><strong>Rec Acc</strong></td> <td align="center"><strong>Miss</strong></td> <td align="center"><strong>Dept</strong></td> <td align="center"><strong>Date</strong></td> <td align="center"><strong>Ref</strong></td> <td align="center"><strong>Details</strong></td> <td align="center"><strong>Unit Amnt</strong></td> <td align="center"><strong>T9</strong></td> <td align="center"><strong>0</strong></td> <td align="center"><strong>Curr</strong></td> <td align="center"><strong>User</strong></td> </tr> </table></th> </tr> </table> Dept (Department) obtained from Stock Item. '''Prize''' <table width="1014" height="71" border="1" cellpadding="1" cellspacing="1"> <tr> <th scope="row"><table width="1162" height="71" border="1" cellpadding="1" cellspacing="1"> <tr> <th scope="col">SI</th> <th scope="col">Cus Acc</th> <th scope="col">Miss</th> <th scope="col">Dept</th> <th scope="col">Date</th> <th scope="col">Ref</th> <th scope="col">Details</th> <th scope="col">Unit Amnt</th> <th scope="col">T9</th> <th scope="col">0</th> <th scope="col">Curr</th> <th scope="col">User</th> </tr> <tr> <th scope="row">BP</th> <td align="center"><strong>Rec Acc</strong></td> <td align="center"><strong>Miss</strong></td> <td align="center"><strong>Dept</strong></td> <td align="center"><strong>Date</strong></td> <td align="center"><strong>Ref</strong></td> <td align="center"><strong>Details</strong></td> <td align="center"><strong>Unit Amnt</strong></td> <td align="center"><strong>T9</strong></td> <td align="center"><strong>0</strong></td> <td align="center"><strong>Curr</strong></td> <td align="center"><strong>User</strong></td> </tr> </table></th> </tr> </table> Dept (Department) obtained from Stock Item or if that is absent, then taken from general Prize Department set up in the General Accounts Info utility. NB. For prize transactions - Details = Prize Chq. No. – X. __'''OVERPAYMENT TRANSACTION'''__ See Credit Note. __'''REPAYMENT TRANSACTION'''__ See Refund. __'''GUIDE TO PROCESS'''__ __'''NOMINAL CODES'''__ [Nominal-Codes|Nominal Codes] Before doing any accounts export into Sage, please be aware of the following: 1) Check that all the relevant Nominal codes are set up correctly, you can check this by going to: Utilities > Accounts > General Accounts Info If you are not sure how to set up your nominal codes please refer to the "General Acounts Info" screen: [image||{UP}/ExportAccounts5.jpg] __'''EXPORTING ACCOUNTS'''__ 1) Go to Accounts > Export Accounts. [image||{UP}/ExportAccounts1.jpg] 2) Search the type of Accounts you want to export to Sage. [image||{UP}/ExportAccounts2.jpg] 3) Select the items you would like to export and click on Export. 4) Items will be exported into an Accounts folder in an excel document, the default path is: C:\Accounts\accounts…csv [image||{UP}/ExportAccounts3.jpg] 5) A message box will come up saying “Export complete". Exported to C:\Accounts\accounts …csv 6) Import the data into Sage from the excel file you have just created. [image||{UP}/ExportAccounts4.jpg]
Meta Keywords:
accounts, export, import, sage, transaction
Meta Description:
Change Comment:
ScrewTurn Wiki
version 3.0.3.555. Some of the icons created by
FamFamFam
.