Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHi, I am helping a small business utilize their QuickBooks Online software more. They use it to start invoices but then use a handwritten log for pretty much everything else, including writing the check number when they receive payment. They do not even send the invoices from QB. Literally, all they do is type up the invoice and then save it to the computer and print it. They likely will set up their bank accounts with QB but for the time being they will not. As it stands there are hundreds of "unpaid" invoices making it impossible to really utilize the software very well.
Can I just go in and manually add each payment as if I had the check in front of me and then do one big bank deposit? Should I just "zero" out the invoices? They use a CPA so I know all the taxes and everything is being collected correctly as far as Uncle Sam is concerned, this is just to clean up their QB so it can be utilized in the coming months.
I have searched the community for help, but really only come across things that require the bank account to be linked to QB, which is currently not an option.
Hey there, @ashleyamdj13.
Thanks for reaching out to us. I feel sad to hear they didn't take advantage of QuickBooks Online. I appreciate you for helping them.
Taking one big deposit for all payments affects the financial reports in QBO. Though, it would be a great help to catch up on accounting and get them on track in the coming months. I recommend seeking advice from their CPA for the best way to handle this.
As another option, I suggest getting an updated list of their bank transactions. They can download them from their bank's website. Then, record invoice payments manually based on the bank statement.
Here's how:
Keep me posted on your progress in helping them establish an appropriate accounting system. I'll be here on hand in any way that I can.
You can ask them to record the Invoices and Receive Payments data with the following template
Invoices
| RefNumber | Customer | TxnDate | DueDate | ShipDate | ShipMethodName | TrackingNum | SalesTerm | Location | Class | BillAddrLine1 | BillAddrLine2 | BillAddrLine3 | BillAddrLine4 | BillAddrCity | BillAddrState | BillAddrPostalCode | BillAddrCountry | ShipAddrLine1 | ShipAddrLine2 | ShipAddrLine3 | ShipAddrLine4 | ShipAddrCity | ShipAddrState | ShipAddrPostalCode | ShipAddrCountry | PrivateNote | Msg | BillEmail | BillEmailCc | BillEmailBcc | Currency | ExchangeRate | Deposit | ToBePrinted | ToBeEmailed | AllowIPNPayment | AllowOnlineCreditCardPayment | AllowOnlineACHPayment | ShipAmt | ShipItem | DiscountAmt | DiscountRate | TaxRate | TaxAmt | DiscountTaxable | LineServiceDate | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineClass | LineTaxable |
| 101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | MP3 Player | Blue MP3 Player | 2 | 55 | TAX | |||||||||||||||||||||
| 101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | Leather Case | Leather Case | 2 | 10 | TAX | |||||||||||||||||||||
| 101 | Janice Johnson | 01/10/2020 | 01/12/2020 | Ground | Net 30 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | 110 Main Street | Suite 2000 | Dallas | TX | 99875 | Special Handling | Thank you for your order! | 0 | N | Y | N | N | Y | 12 | Shipping | 0.02 | Y | Gift Cards | Gift Cards | 2 | 5 | TAX | |||||||||||||||||||||
| 102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Handhelds | Portable Game Player | 1 | 100 | TAX | |||||||||||||||||||||||||||||
| 102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Software | 1 Year Warranty | 1 | 25 | TAX | |||||||||||||||||||||||||||||
| 102 | Leonard Walker Inc | 01/10/2020 | Net 30 | 9 Winding Road | Winchester | NY | 12345 | 9 Winding Road | Winchester | NY | 12345 | Thank you for your order! | 0 | Y | N | N | N | Y | Y | Extended Warranty | 1 Year Extended Warranty | 1 | 5 | TAX | |||||||||||||||||||||||||||||
| 103 | Lisa Smith | 01/10/2020 | Net 30 | 19 Jerico Drive | Bensalem | PA | 84256 | 19 Jerico Drive | Bensalem | PA | 84256 | We appreciate your business! | 0 | N | Y | N | N | Y | Gift Certificate | $50 Gift Certificate | 1 | 50 | NON | ||||||||||||||||||||||||||||||
| 103 | Lisa Smith | 01/10/2020 | Net 30 | 19 Jerico Drive | Bensalem | PA | 84256 | 19 Jerico Drive | Bensalem | PA | 84256 | We appreciate your business! | 0 | N | Y | N | N | Y | Magazine Subscription | Annual Magazine Subscription | 2 | 12 | NON |
Receive Payments
| RefNumber | TxnDate | PaymentRefNumber | Customer | PaymentMethod | DepositToAccount | InvoiceApplyTo | LineAmount | PrivateNote | Currency | ExchangeRate |
| 1 | 28/11/2020 | 50245 | Janice Johnson | Check | Checking | 101 | 100.00 | |||
| 2 | 28/11/2020 | 4908 | Leonard Walker Inc | Check | Checking | 102 | 138.78 | |||
| 3 | 28/11/2020 | 4908 | Lisa Smith | Check | Checking | 103 | 126.50 |
then utilize an importer tool
https://transactionpro.grsm.io/qbo
You can also utilize thee trial version of a backup restore app to minimize any rookie's mistake
https://rewindio.grsm.io/quickbooks
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here