Welcome Guest, you are in: <root> • Login

Page History: Exporting Accounts to Sage

Compare Page Revisions

67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 23/08/2011 11:15 AM

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:

@@@@

Showbiz Transaction	Export File countrtpart(s)	Notes
1	1	1
2	2	2
3	3	3
4	4	4
5	5	5
6	6	6

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 2

Prize

N/A

RECEIPT TRANSACTION

General

table 3

Prize

N/A

CREDIT NOTE TRANSACTION

General

table 4

Cus Acc, NC and Dept the same as the ‘parent’ invoice.

Prize

table 5

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 6

Dept (Department) obtained from Stock Item.

Prize

table 7

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

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:



EXPORTING ACCOUNTS

1) Go to Accounts > Export Accounts.



2) Search the type of Accounts you want to export to Sage.



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



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.