Streamline Your Cleaning Company Invoice for R&D with Ease

Cleaning company invoice for R&D

what would happen if i am in the middle of my reconciliation let's go back to reconcile and i'm to the point where everything is marked because it did it automatically or because i went in one by one and i checked it and i got to zero and there's stuff sitting there so generally when you have transactions sitting in your in your um in your bank reconciliation screen that's because maybe they belong to previous periods and we already have sort of uh cleaned up the previous periods and forced adjusted that beginning balance maybe they will show up on the next reconciliation judging by the dates in this particular case and judging by the fact that they don't have a clear date next to them that means that these are probably erroneous transactions so i basically got two choices delete them and that's if i don't want to affect if i don't care about affecting 2020 i would just delete them or if if i don't want to affect 2020 because it's already been closed and cleaned up and i don't want to delete them to mess up those books or maybe there's a closing date password then i would simply just reverse them okay and we'll we'll explain what that means so i'm gonna click on finish now and then i have officially reconciled my credit card i'm gonna go into the balance sheet i'm going to go into balance sheet and i'm going to click on my credit card my 3375 i will click on that and then all my transactions are showing up in here now when i click on the gear menu on the right there's actually a little checkbox that says clear on it if i click on that checkbox i can actually see which transactions have cleared the bank and which ones have not so there should be two transactions sitting here let me do all dates here there should be two transactions sitting here that haven't cleared the bank which is the 101 506 and the 51.98 again as i explained earlier if you are okay with modifying these are 20 20 transactions modifying your 2020 financial statement then you can just go in there and delete them manually one by one if you don't want to affect 2020 then you have to reverse them really important so there's a couple ways to do it one you can just do a general journal entry against the sum of these two um and then choose whatever account you want and this will be sort of a fudge account an account that we're doing just so we can sort of clean that up and we're accepting that that's not necessarily accurate or we can reverse it against the original category that it was that it was for and the only way to truly do that is to kind of summarize it in um in excel just because there might be more than one transaction in this particular case this is pretty easy we can do a journal entry to reverse because it's only two but if you happen to be more we're gonna customize this report and we're going to filter out clear transactions and we're going to show unclear transactions and click on run report that's going to now summarize all my unclear transactions after again after i reconciled already the first month and i know that everything i'm looking at is prior to my first clean reconciliation then at that point you could probably export this to um to to excel um you can you can't do it from here unfortunately but you can export this to excel and then group them by the split and then you get the dollar amounts and then you do your journal entry what would the journal entry look like well i'm going to click on the new transactions and click on journal entry and this would be one journal entry for repairs and maintenance and another journal entry for let's take a look at that for meals and entertainment again if you have a whole bunch of transactions you would get this report into excel and summarize by category because i'm reversing errors from the past it's going to be 101.56 so this would be uh 101.56 and then this would be 51.98 and then the difference here is going to go to that chase visa 3375 and then the journal date in this case let's do 1 1 20 21 again because we don't want to affect 2020 and this essentially reverses any unreconciled transactions just sitting there on the register this is the same case for reversing bank transactions or open checks that didn't get paid last year or never got paid or all checks are sitting there forever it's going to be the exact same case so let's go back i'm going to go back and reconcile again i'm going to reconcile the exact same month 0 1 26 21 ending date sorry i'm going to put this in dollar amount and reconcile the same month 0 1 26 21 click on start reconciling and now to get rid of these transactions again previous period we don't want to affect previous period we reversed on the current period then we select them all and then we click on finish now and we basically reconcile him in that second step once we know what doesn't belong in my regular real reconciliation now in order to avoid confusion generally what i do is i'll push the reconciliation one more day that way i can have a clean reconciliation for 126 and then i have a separate reconciliation just for 127 so you can see them in two separate reports and i can see my report that is an adjustment report in nature and then i can see the report that's a clean reconciliation in nature so i'm going to click on save and i essentially cleaned out my old balances and my old transactions by reconciling them against a adjusting entry you