print documents from the ledger in the numerical order

Is someone who can help me to print out the documents from the ledger in the numerical order (that is, for tax purposes, or else I have to stop using Turbocash)

Views: 41

Reply to This

Replies to This Discussion

Not sure which documents you are referring to?

  • Is it a listing of your General Ledger transactions?
  • Is it printing out the actual invoices that you provided to customes (and credit notes), with your copmpany detail and logo?
  • Is it printing out a listing of the invoices you issued, i.e. without the logo and layout, just the detail?

r

Thank you for answering.

Is it a listing of your General Ledger transactions? Yes it is
It is possible to print a lot from the sales system and the business accounts, but not the financial accounts from the ledger. I need to print the bills I have booked in the order they are booked.


Retief Kotze said:

Not sure which documents you are referring to?

  • Is it a listing of your General Ledger transactions?
  • Is it printing out the actual invoices that you provided to customes (and credit notes), with your copmpany detail and logo?
  • Is it printing out a listing of the invoices you issued, i.e. without the logo and layout, just the detail?

r

I'm still a bit confused with terms you use, as from my point the 'business accounts' = 'financial accounts' = 'general ledger'.   The information contained in this will be a 'summary' of the 'invoice detail lines' kept in the 'Sales'/'Debtors' ledger.

Let's start with two reports and see if any of that provides the information you're looking for:

Report 1: Document Listing: Provides single line per Invoice (with only the total per document)

  1. Click on 'Reports' in top menu and then 'Reports' in the second-row icons
  2. Select 'Documents' (4th from the bottom), and then select 'Document Listing' (1st in next list)
  3. On the next screen:
    1. Select the date-period you want to cover: e.g.
      1. Select 'year' in the box below the drop-down, and then
      2. Select the relevant year from the drop-down
    2. Document type = 'Invoice'
    3. Sequence = 'Document No.' or 'Date issued' (or whatever other sequence you prefer)
    4. Click 'OK'
  4. In the next screen should be a listing displayed
    1. You can page around if  there are mutiple pages
    2. or 'Print' with the next button
    3. or 'Export' in the next button
      1. In the next screen you can slect 'PDF', Excel, etc in 'File Type'

Report 2: Print the 'Income' accounts from your General Ledger (this provides ex-VAT amounts)

  1. Click on 'Reports' in top menu and then 'Reports' in the second-row icons
  2. Select 'Ledger' (3rd from the top), and then select 'Transactions' (last in next list)
  3. On the next screen:
    1. Select the date-period you want to cover: e.g.
      1. Select 'year' in the box below the drop-down, and then
      2. Select the relevant year from the drop-down
    2. 'From Account' = the first Income/Sales Account in your General Ledger
    3. 'To Account' = The last Income/Sales account in your General Ledger
    4. Sequence = 'Account'
    5. 'Include opening balances' = no tick
    6. Click 'OK'
  4. In the next screen should be a listing displayed
    1. You can page around if  there are mutiple pages
    2. or 'Print' with the next button
    3. or 'Export' in the next button
      1. In the next screen you can slect 'PDF', Excel, etc in 'File Type'

If neither provides what you're looking for, can you elborate what is wrong or lacking from them?

r



Retief Kotze said:

I'm still a bit confused with terms you use, as from my point the 'business accounts' = 'financial accounts' = 'general ledger'.   The information contained in this will be a 'summary' of the 'invoice detail lines' kept in the 'Sales'/'Debtors' ledger.

Let's start with two reports and see if any of that provides the information you're looking for:

Report 1: Document Listing: Provides single line per Invoice (with only the total per document)

  1. Click on 'Reports' in top menu and then 'Reports' in the second-row icons
  2. Select 'Documents' (4th from the bottom), and then select 'Document Listing' (1st in next list)
  3. On the next screen:
    1. Select the date-period you want to cover: e.g.
      1. Select 'year' in the box below the drop-down, and then
      2. Select the relevant year from the drop-down
    2. Document type = 'Invoice'
    3. Sequence = 'Document No.' or 'Date issued' (or whatever other sequence you prefer)
    4. Click 'OK'
  4. In the next screen should be a listing displayed
    1. You can page around if  there are mutiple pages
    2. or 'Print' with the next button
    3. or 'Export' in the next button
      1. In the next screen you can slect 'PDF', Excel, etc in 'File Type'

Report 2: Print the 'Income' accounts from your General Ledger (this provides ex-VAT amounts)

  1. Click on 'Reports' in top menu and then 'Reports' in the second-row icons
  2. Select 'Ledger' (3rd from the top), and then select 'Transactions' (last in next list)
  3. On the next screen:
    1. Select the date-period you want to cover: e.g.
      1. Select 'year' in the box below the drop-down, and then
      2. Select the relevant year from the drop-down
    2. 'From Account' = the first Income/Sales Account in your General Ledger
    3. 'To Account' = The last Income/Sales account in your General Ledger
    4. Sequence = 'Account'
    5. 'Include opening balances' = no tick
    6. Click 'OK'
  4. In the next screen should be a listing displayed
    1. You can page around if  there are mutiple pages
    2. or 'Print' with the next button
    3. or 'Export' in the next button
      1. In the next screen you can slect 'PDF', Excel, etc in 'File Type'

If neither provides what you're looking for, can you elborate what is wrong or lacking from them?

r

Thank you for answering again.

Is it a list from  General Ledger, transactions in number sequence yes it is.

'business accounts' = 'financial accounts' = 'general ledger'.

Your second answer is closer

I'm not selling or buying and not using it.

What I have come closest to print is this, but instead of an account should be transactions in sequence order not in account order.

Halldór Ingi

Hi,

If I understand correctly, you don't have debtors or creditors.  Are you only entering cashbook-entries?

The only other option I could find that I think is nearest to whart you want as follows:

  1. Click on 'Reports' in top menu and then 'T-Ledger Analysis' in the second-row icons (3rd from left)
  2. Select the period from the drop-down in the next frame below, and 'Report Type' as 'Trial Balance' in the area to the right
  3. Click on 'Report' on the left  (any time you change any of the dates or options you have to click 'Report' for the report belo to 'refresh'
  4. In the report below, right-click on any of the totals or subtotals that you want the detail of, and select "Show detail"
  5. In the next screen, select 'Export' and then select your file-type as TXT or CSV
  6. Open the exported file
    1. it contains the batch number as part of the detail
    2. The batch number can be used to sort the data in the order it was entered
    3. The amounts are ex-VAT

You mentioned in your first post that this was for Tax-purposes:

  • Is it for Income Tax (annual), or
  • is it for VAT/SalesTax (monthly or bi-monthly)

If you are only using the cash-book to enter your bank account entries, then you might want to consider printing the 'Batches' for the bank account, as follows:

  1. Click on 'Reports' in top menu and then 'Reports' in the second-row icons
  2. Select 'Batch Entry' (3rd from the top),
  3. In the next screen select 'Batch transactions per period' in the top drop-down
  4. Select the period as described before
  5. On the right select the specicif batch-type you want to view/export, in this case it will be something link 'Bank payments batch' or 'Bank Receipts batch'
  6. Click OK
  7. In the next screen should be a listing displayed
    1. You can page around if  there are mutiple pages
    2. or 'Print' with the next button
    3. or 'Export' in the next button
      1. In the next screen you can slect 'PDF', Excel, etc in 'File Type

I hope this helps.  If not, then the only other option(s) I can think of is to create a custom Excel-file to extract data via SQL-command in the format you want.

Thank you very much for your help, this solves my problem. 

I had no idea of this CSV option within the program and I'm defiantly going to look further into that in the future.

I'm surprised that this does not exist as a printout option, just change: sort by "account" to "transaction sequence" options this would be very useful

Again, thank you so much for your help. 

Kind regards, 

 

Halldór Ingi

I'm glad to be able to help.

Printout feature: The only way at this point is to submit it as a 'Feature request'.  The required data exist in the database, i.e batch-number and line-number within each batch.

Take care.

r

Reply to Discussion

RSS

Blog Posts

Open source software and economic inequality

Posted by Philip Copeman on May 4, 2017 at 14:00 0 Comments

Open source software offers Governments the opportunities to build the knowledge economy and built it inclusively.

The World Economic Forum roadshow is back in town again. Economic experts on sponsored trips with generous expense accounts check into the beach front hotels amid fan fair and flashing cameras. They are offering us more advice than President Trump gets. Exotic terms like “inclusi…

Continue

There Are As Various Kinds Of Grass As Flowers

Posted by Kirsten Sue on December 19, 2016 at 17:50 0 Comments

CSA is Community Supported Agriculture, that is far more fresh produce. It is actually opportunity to participate a great environment that provides sustainably grown manufacture and to ascertain additional concerning the community and ecology that provides these merchandise for u . s citizens.

Your first phase to having an excellent six packs diet is counting your calorie absorption. You can download an excellent calorie counter on the online world. Once you do this…

Continue

TurboCASH Subscription December

Posted by Philip Copeman on December 7, 2016 at 0:04 0 Comments

If you would like to get the maximum out of TurboCASH Accounting and your Windows 10 PC, sign on for the TurboCASH 5 subscription at $60 per year. The new version makes it a whole lot easier to run a paperless office using PDF filing, Accounting Made Easy is included. Spend a few hours on improving your understanding of finance this month and start the new year with a boost.

Buy N…

Continue

How Trump beat his taxes.

Posted by Philip Copeman on November 15, 2016 at 11:30 4 Comments

 Unless you have been under a rock for the last 6 months, you must have followed how President Elect Donald Trump avoided income tax over the last few years. He did this by using Depreciation!

Its all legal of course and most Governments offer you this…

Continue

Events

Videos

  • Add Videos
  • View All

© 2017   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service