So it's entirely up to you, use the first method, or the second method or, perhaps like the majority of businesses, a mix of both. Hit the reconcile link and this puts the green tick next to the entry in the bank record.īecause the transaction has already been entered by you days or weeks previously, there is no need for an Add transaction stage. Upload the bank statement and hit the entry to explain it only this time, you'll not see an unpaid invoice to allocate the payment against, you'll see the Invoice with a PAID against it and a "reconcile" link. This puts the entry in the bank and sales records (ie the first manual stage noted at the start). Go to the invoice screen and use the quick pay boxes to show that it's been paid off. In such a situation the process for these items is as follows: The benefit of this is that if you only upload your bank statements every month, you still want to record the fact that your customer has paid off their invoice, (or you have paid off a bill) otherwise you could end up chasing them again in a couple of weeks time (or paying the bill twice - I've done this!). Many businesses however (maybe >50%) still want to follow the two stage method for some entries, ie they want to make a manual entry in the books before the bank statement arrives. So, if you then open the bank account record, you will now see the entry in the account with a green tick next to it. Once happy, hit Add transaction and this stick it in the books and covers the two manual steps noted above, ie both making the book entries and ticking off the entries in the bank record. Upload bank statement (This just gives you pages of bank statement entries so, at that stage nothing has been entered in the books).Ĭlick on each line and tell "EXPLAIN" to CBs what it is, which, in your example, is allocating the amount against the one (or many) unpaid sales invoices. In CBs, and other systems which allow the import of bank statement lines every day if you want, the above two processes can take place in one go but in reverse order, ie you are lead from the bank statement. Then, as a second stage, when the bank statement arrived at the end of the month, you would run down it and tick off all the entries on the statement with the entries in your cash book and this process was part of the "Bank Reconciliation". In traditional bookkeeping when a customer paid you, you would make a double entry in your books to add the money in to your cash book (ie your internal bank record) and then to pay off the unpaid invoice in your Sales Ledger (ie the book recording invoices sent out and money to pay them off). If you change the text in a cell, so that it contains 'Oil', the formatting automatically changes.If I set out where these terms originated, I think it will give you a better insight into why CBs does what it does and why there are two procedures open to you depending on how you want to run your books, ie there is no "correct" procedure. I am leaving the formatting set to the default.Īnd the cells that contain 'Oil' are formatted in red. Notice the formatting options for text are different than those for money.įormatting options differ between many different types of data. You can also apply conditional formatting to text. Select the cells, click the button, and click another format option, such as Icon Set.īy default, these indicate the upper third, middle third, and lower third of the values. You can apply multiple conditional formats to the same cells. When I move across the formatting options, a live preview shows me what my data will look like.ĭata Bars provides what I want, so I click it.Īnd now, I have an eye catching visual representation of the data, making it easier to analyze. I select the range of cells in Sales, click the Quick Analysis button, use the default FORMATTING tab. I want to see how much each Salesperson sold. Conditional formatting provides visual cues to help you make sense of your data.įor example, it'll clearly show highs and lows, or other data trends based on criteria you provide.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |