TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
About
Link to us!
Forum
Consultants
Support
Links
Sitemap
Free Downloads
TurboCASH Accounting
TurboCASH Source Code
Chart of Accounts
Fonts
Shop
TurboCASH CD
 Accounting Made Easy Ebook
TurboCASH Portable
Other Titles
Faswin Fixed Asset Software
Job Costing Software
Antivirus / Virus removal
Inkjet Cartridges
Accounting Stationery

Using TurboCASH
New To Accounting
Setup: Service Entities
Setup: Retail Entities
Which Batch/journal?
Set up chart of accounts
Enter transactions
Point of Sale
Help topics
Accounting terms
Developers
Open Source
A History
Reference Guide
Fonts
A  B  C  D  E  F  G
H  I  J  K  L  M  N
O  P  Q  R  S  T  U
V  W  X  Y  Z

 







EXPORT DATA
EXPORT POSTED BATCHES TO AN EXCEL SPREADSHEET FILE
  
The Posted Batches records or data are saved in a Microsoft Excel file when the data is exported in the Tools - Export menu option on the Posted Batches tab and the Excel Type is selected. Once the data for general ledger accounts have been saved to a file, you may access the file by locating it in the specific location and file name where you have saved this file on your system. You may use this Excel file to analyse and sort this data for your specific requirements or to Import Posted Batches.

To access the Microsoft Excel file:
 Locate the file on your system. You may use the Windows Explorer .
Double-click on the icon with the name you have saved the specific data for the exported debtor file. The selected file will be displayed.

Title bar - program name. Title bar - name of the saved exported file. Restore button - click to restore the program to the size in which the progam was displayed. Close button - click to close or exit the program. Minimise button - click to minimise the program. Menu bar - click to access the menu options in the program. Minimise button - click to minimise the active spreadsheet. Restore button - click to restore the spreadsheet to the size in which the progam was displayed. Close button - click to close or exit the active spreadsheet. Program name and icon. New - click to open a new spreadsheet. Open - click to open an existing spreadsheet. Save - click to save the data or your changes in this speadsheet. Print - click to print this spreadsheet or the selected cells. Print preview - click to view this spreadsheet or selected data. Spelling. Cut - removes the contents of the selected cells and places it on the Clipboard. Copy - places the contents of the selected cells on the Clipboard. Paste - places the contents from the Clipboard into the selected cells of the active spreadsheet. Format Painter Undo - click to undo a last or previous action. Undo - click to select an action to undo. Redo - click to redo a last or previous action. Redo - click to select an action to redo. Insert a Hyperlink Show or Hide Web Toolbar. Auto Sum - to insert a formula in a selected cell. Paste Function Sort Ascending Sort Descending Font - select a font. Bold. Italic. Underline Align Left Align Centre Align Right Merge cells and align centre across cells. Currency. Percentage Style Comma Style Increase Decimal Decrease Decimal Decrease Indent Increase Indent Chart Wizard Map. Drawing. Zoom - click to select a size to view the spreadsheet. Office Assistant Borders. Fill Colour Font Colour Name Box - displays the column and row of cells Formula bar - displays the contents or a formula for selected cells. Columns. Scroll bar Row 1 - Headings for the exported data fields. Batch ID. TurboCASH generates a unique number for each batch created. Name or Description of the Batch or Journal. Account number or code. This may be a General Ledger, Debtors or Creditors Account. Tax code or VAT account number. Description or details of the transaction. Line or row number indicates the number of the transaction entered in a batch. Date of the transaction. Accounting period ID. (1 to 13 = Last Year and periods 14 to 26 = This Year). Rows. Rows 2 to the end - the data for each account. Contra Account number or code. User Name - The name of the User which created the batch, if Users were created in the Setup Access Control menu option. Reference to source document number or transactions as entered in the reference field. Transaction amount. Credit amounts are preceded by a minus (-) sign. Font size - click to select a font size. Unique ID. Name of the Alias. Tax Percentage. Exported Posted Batches in Mucrosoft Excel

 

The data fields exported from your general ledger account records is exported in columns, and the data, which you have entered in the Input - Batch Entry menu option is displayed in rows (from row 2 onwards). Each transaction account data is listed in its own row. Row 1 is used for the headings of the TurboCASH data fields.

The vertical scroll bar is located on the right-hand side of the spreadsheet file and is used to view more data for transaction data. The horizontal scroll bar is located at the bottom of the spreadsheet file and is used to view more data fields for transaction data.

The data fields on the screens in TurboCASH and the columns in which the data is displayed in the Microsoft Excel spreadsheet is as follows:



An Exported Posted Batch with VAT transactions:

The detail for the columns is as follows:

Column Field Account - Details Values
A Batch Type The name for the batch type as Setup - System Parameters - Batch Type menu option. Alpha-numerical
B Account The selected account and tax account (if selected). Alpha-numerical
C Tax Account The Tax Account which is applicable to a transaction. Alpha-numerical
D Contra-Account The specified or selected account in the Batch Setup option. Alpha-numerical
E User name The name of the user if created in the Access Control menu option. Alpha-numerical
F Description The description for the transaction as entered in each line. The last transactions, which is indicated by ******** (8 asterisks) is generated by TurboCASH when the batch is balanced. Alpha-numerical
G Unique ID TurboCASH generates the Unique ID. Numerical
H Alias The Alias as displayed in the Title bar of the Batch Entry screen. The alias is changed on the Processing Options for the Batch. Alpha-numerical
I Batch ID or number TurboCASH generates the Batch ID (or number). Numerical
J Line ID or number The line number for the transaction in a batch. Numerical
K Date The date of the transaction. Date
L Period ID The ID for the accounting period for the transaction date. Numerical
M Reference The reference number or source document number (e.g. cheque number, etc.) for the transaction. Alpha-numerical
N Amount The amount of the transaction. Amount
O Tax Rate The percentage which applies to the selected Tax Code Percentage
P Tax Amount The amount is calculated as a percentage of the amount in column L if a Tax Account was selected for the transaction. Amount
Q Tax Rate 2 The tax percentage of the second tax account if a Tax Account was selected for the transaction. Numerical
R Tax 2 Amount The amount is calculated as a percentage of the amount in column L if a second Tax Account was selected for the transaction. Amount
S Forex The forex value is currently 1 for all transactions. Amount

GNU Free Documentation License 1.2 SourceForge
Content released by Digidan under the GNU Free Documentation License 1.2.

  

© 2010 TurboCASH · All Rights Reserved
Home · Features · Purchase · Compare · FAQ · Press · Register · Contact · Site map