A/ Xero - Previous A/R

USA Discussion in 'Technical Queries' started by BellaAccounting, Feb 7, 2019.

  1. BellaAccounting

    BellaAccounting

    Joined:
    Feb 7, 2019
    Messages:
    1
    Likes Received:
    0
    I have a client who uses Xero, and when I run the balance sheet from 2017 the numbers have changed from last year.

    Last year he had a negative AR of $5000 because of pre-payment that was made at the end of the year.
    This year when I run the report it shows a positive $6000 for AR and a decrease in the bank balance.

    The P and L is a prefect match when run again from the report run in 2017.

    For the life of me I cannot find out how this happened. I have reviewed invoices, gone through AR line by line. I'm just stumped.
    Any direction would be appreciated.
     
    BellaAccounting, Feb 7, 2019
    #1
    1. Advertisements

  2. BellaAccounting

    kirby VIP Member

    Joined:
    May 12, 2011
    Messages:
    1,446
    Likes Received:
    200
    For both the affected A/R account and Cash accounts, run a report showing journal entry POSTING DATE and EFFECTIVE DATE (assuming the Xero system has these fields). Then look for cases where something was posted in year A but effective in Year B.
    Also, see if reports have options to be printed using either effective date or posting date.
    Bottom line - you will ultimately find which case is your reality as of end of 17 as the Cash acct was involved and you can determine if that transaction truly happened or did not via Bank Recon.
     
    Last edited: Feb 9, 2019
    kirby, Feb 9, 2019
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.