Sage report question

Discussion in 'Accounts & Finance' started by MarkyJenkins1980, Aug 12, 2019.

  1. MarkyJenkins1980

    MarkyJenkins1980 UKBF Newcomer Free Member

    6 0
    good morning all,

    I am looking for a sage wiz if poss to help me find the correct report.

    Excuse my lack of knowledge in this field.

    I would like to know how much money the company is left with at a particular given point. I understand last month may be difficult to ascertain but would like to think I could have it from June?

    I would like to know a total amount if poss, so money in the back unpaid invoices against unpaid suppliers so basically what’s left.

    That’s if there is such a report.

    Many thanks for your help in advance.
     
    Posted: Aug 12, 2019 By: MarkyJenkins1980 Member since: Aug 11, 2019
    #1
  2. johndon68

    johndon68 UKBF Big Shot Full Member - Verified Business

    3,392 618
    Assuming that you haven't cleared the Audit Trail at a date after you want to run the report for, the Transactional Trial Balance report can be run to a given date and would give you the balance on all nominal accounts at that date.

    John
     
    Posted: Aug 12, 2019 By: johndon68 Member since: Nov 2, 2009
    #2
  3. MarkyJenkins1980

    MarkyJenkins1980 UKBF Newcomer Free Member

    6 0
    Hi John,

    Many thanks for the response, please excuse me as this is not my field.

    So to clarify I will run a report called transactional trial balance up to say the 30th June and look at the total at the bottom of the page?

    Many thanks

    Mark
     
    Posted: Aug 12, 2019 By: MarkyJenkins1980 Member since: Aug 11, 2019
    #3
  4. johndon68

    johndon68 UKBF Big Shot Full Member - Verified Business

    3,392 618
    Not the total at the bottom of the page - I assume from your original post you want to know how much is in the bank? The bank account balance will be listed on the Trial Balance report.

    John
     
    Posted: Aug 12, 2019 By: johndon68 Member since: Nov 2, 2009
    #4
  5. MarkyJenkins1980

    MarkyJenkins1980 UKBF Newcomer Free Member

    6 0
    Hi John,

    I am trying to figure out what the total we should have in the bank (I get some people wouldn’t of paid etc) but would like to know in theory what it should be? I understand last month will be inaccurate as all the invoices from suppliers may not be in yet but would like to get an idea of what we should potentially have.

    Thanks

    Mark
     
    Posted: Aug 12, 2019 By: MarkyJenkins1980 Member since: Aug 11, 2019
    #5
  6. johndon68

    johndon68 UKBF Big Shot Full Member - Verified Business

    3,392 618
    The Aged Debtor and Aged Creditor reports will show you how much you were owed by Customers and how much you owed to Suppliers at a given date if that helps...

    John
     
    Posted: Aug 12, 2019 By: johndon68 Member since: Nov 2, 2009
    #6
  7. MarkyJenkins1980

    MarkyJenkins1980 UKBF Newcomer Free Member

    6 0
    Hi John,

    Is that the only way? I have wages bills etc and was hoping there was a report that would calculate it all for me?

    Thanks

    Matk
     
    Posted: Aug 12, 2019 By: MarkyJenkins1980 Member since: Aug 11, 2019
    #7
  8. johndon68

    johndon68 UKBF Big Shot Full Member - Verified Business

    3,392 618
    It sounds like you are looking more for a Cashflow report?
     
    Posted: Aug 12, 2019 By: johndon68 Member since: Nov 2, 2009
    #8
  9. MarkyJenkins1980

    MarkyJenkins1980 UKBF Newcomer Free Member

    6 0
    Hi John,

    I have looked at cash flow and not really what I am after, maybe I am note describing it correctly.

    Ok if for example I stopped trading today but wanted to k ow what I am left with even though I have been paid from everyone yet nor paid drivers, suppliers bill etc what would be left? I Want to go back to June as I know everything is on sage up until the end of June accurately.
     
    Posted: Aug 12, 2019 By: MarkyJenkins1980 Member since: Aug 11, 2019
    #9
  10. johndon68

    johndon68 UKBF Big Shot Full Member - Verified Business

    3,392 618
    Still not sure I completely understand but, if wages for example, haven't gone through Sage then there is no way that they could be included in a report to tell you what the balance on the bank account should be...

    John
     
    Posted: Aug 12, 2019 By: johndon68 Member since: Nov 2, 2009
    #10
  11. MarkyJenkins1980

    MarkyJenkins1980 UKBF Newcomer Free Member

    6 0
    Hi John,

    Yes everything is on sage as it should be! I would just like to know what my total net would be after everything I have paid for and what I have invoiced out would be left to me?
     
    Posted: Aug 12, 2019 By: MarkyJenkins1980 Member since: Aug 11, 2019
    #11
  12. NicoJ

    NicoJ UKBF Regular Free Member

    103 14
    I don't think that SAGE has a report for what you want. If your bank is reconciled up to date, take that and then produce an aged debtors and aged creditors. Bank balance + debtors - creditors is the answer that I think you're looking for.
    Of course the caveat to this is it will only tell you the correct answer if all of the information has been correctly entered into the system.
     
    Posted: Aug 12, 2019 By: NicoJ Member since: Mar 27, 2017
    #12
  13. Scalloway

    Scalloway UKBF Legend Free Member

    15,048 3,189
    Just run a profit and loss account then knock of 20% for tax?
     
    Posted: Aug 12, 2019 By: Scalloway Member since: Jun 6, 2010
    #13
  14. UK Contractor Accountant

    UK Contractor Accountant UKBF Big Shot Full Member - Verified Business

    4,607 767
    I think you want the balance sheet report at 30 June 19.

    That will give you the net worth of the business after everything - assuming it has all been entered corectly. Corporation tax you could enter as a provision based on 19% of the profit for the period.
     
    Posted: Aug 12, 2019 By: UK Contractor Accountant Member since: Sep 18, 2013
    #14