About
Applies to: Finaloop Accounting, InventoryIQ
Finaloop Accounting, Finaloop's real-time bookkeeping and accounting service, runs on double-entry accounting: every accounting event, whether a transaction, adjustment or accrual, is backed by a debit and credit journal entry (JE) in the background. These JEs update your General Ledger, Balance Sheet, Profit and Loss statement and Cash Flow statement.
If you're coming from a traditional accounting system like QuickBooks or Xero, you're probably used to seeing detailed JEs for everything, from bank transactions to expense categorization.
Finaloop works differently in order to create and maintain accurate books with the least amount of manual work needed from you or your accountants. We're built for ecommerce brands that want real-time, accurate books without the complexity and delays of manual accounting, and we designed our platform to do much of the heavy lifting behind the scenes.
Sometimes you or your accountant may want to add a JE to report an external transaction, adjustment or accrual, or to reconcile with an external source. In Finaloop, JEs are created in one of 3 ways:
Automatically synced from your connected sources of truth (Automated Journal Entries)
Adjusted directly through our platform (Customized Journal Entries)
Added manually by you in Journal entries or by our accounting team (Manual Journal Entries)
Let's walk through exactly each type of JE and how they work in Finaloop.
1. Types of journal entries in Finaloop
Finaloop gives you the JE capabilities of traditional accounting software, with a streamlined approach designed for ecommerce.
Our mission is to provide fully reconciled and accurate books that require less manual work for you, so you can breathe easy and know you're in good hands!
Automated Journal Entries
These JEs are fully automated, so there's no need to add or edit them.
JEs are automatically imported in real time from your connected data sources using secure API connections. Every transaction is matched to the original source, categorized based on ecommerce best practices, and validated for accuracy.
Because they come straight from your sources of truth, entries from your connected apps can't be edited manually.
These include:
Sales, merchant fees, and undeposited funds (UDF)
Bank and credit card transactions
Payroll data from Gusto
Bills from Settle or Bill.com
Ecommerce loans through PayPal Working Capital, Stripe Capital, and Shopify Capital
Customized Journal Entries
You or your accountant can use Finaloop's built-in tools to enter the adjustment needed, and our system will automatically generate the necessary JE in your books.
These entries are for things that require some input from your side. Instead of asking you to write formal JEs, we've built user-friendly tools that take care of it in just a few clicks.
These include:
Shopify order adjustments (marking orders as void, product giveaways, uncollectible, and so on)
Wholesale invoices
Cost of goods sold (COGS) and inventory
Prepaid expenses and accruals
Recording transactions from an external bank account or credit card
Bills
Payroll (except for Gusto)
Equity adjustments
Manual Journal Entries
When an entry isn't automated and isn't covered by one of our built-in tools, it's recorded as a Manual Journal Entry. You can post it yourself in Journal entries, or our team can take care of it. Entries may be initiated and recorded by us, requested by you or your accountant and reviewed by our team, or posted by you directly.
Examples of Manual Journal Entries that are initiated and recorded by our team include:
Loans that are not automated
Fixed asset depreciation
Intangible amortization
Year-end adjustments
We take full responsibility for the accuracy of the entries our team records and ensure they're properly recorded in your books.
We also know there may be additional adjustments you want to make or that are requested by your accountant. For these, post the entry yourself in Journal entries, or send the details to our accounting team and we'll take care of it.
When you ask our team to record an entry, we review and validate it first. This helps prevent duplicate entries and ensures compliance with accounting best practices and alignment with our system's validations. Entries you post yourself go straight to your books after the same built-in checks that keep every entry balanced.
2. A note to fellow CPAs and bookkeepers
If you're used to manually recording JEs in traditional accounting software, Finaloop's process may feel different. Rest assured that you can post the entries you need yourself, with an extra layer of quality control built in.
We work with many CPAs and bookkeepers and work to save you time while improving accuracy, so you can focus on higher-level work such as filing taxes, providing financial analysis and controllership, or giving strategic advice instead of repetitive, manual data entry.
In Journal entries, each entry needs at least two lines and its debits and credits must balance. You can record an entry on a Cash, Accrual or Both basis, use a foreign currency with an exchange rate, add attachments, and see every change in the History log.
You and your client are in good hands, and if you have any questions, we're here to help!
3. Automated Journal Entries
Let's dive into the type of JEs that are fully automated in Finaloop (no work needed from you!).
Sales and merchant fees from connected sales channels and payment processors
Any transactions or data from Shopify, Amazon, Walmart, Etsy, eBay, Shop Pay, PayPal, Stripe, Amazon Pay, Afterpay, or Klarna are fully automated.
JEs for gross sales, refunds, discounts, merchant fees, selling fees, shipping income, fulfillment fees, advertising, service fees, disputes, sales tax collected, and undeposited funds are automatically recorded, giving you a clear, real-time financial breakdown that aligns with your sources of truth.
Our reconciliation process is built to cover the complexities that arise in various use cases. Here are some examples of how these JEs work, and you can read more in Finaloop's Shopify Integration Deep-Dive.
When a Shopify order comes in:
Debit "Accounts receivable (A/R) - Shopify"
Credit "Sales - Shopify" or "Deferred revenue - Shopify", depending on the specifics of your business setup
When a customer pays via a connected payment processor, for example Stripe:
We sync data from your sales channel, payment processor, and bank payouts using a three-way reconciliation process to match the order data to the payment data to the payout data
Debit "Undeposited funds - Stripe"
Credit "Accounts receivable (A/R) - Shopify"
When Stripe deposits cash into your bank account:
Debit "Money in transit" (until it hits your actual bank account)
Credit "Undeposited funds - Stripe"
When a customer pays via cash payment, for example check, ACH, or cash:
Debit "Accounts receivable (A/R) - cash orders - Shopify"
Credit "Accounts receivable (A/R) - Shopify"
When the payment is received in your bank account, mark it as "Cash payment received for store orders":
Debit your bank account
Credit "Cash payments received for store orders"
"Cash payments received for store orders" is a Balance Sheet account with a negative balance, effectively reducing the net impact of the "Accounts receivable (A/R) - cash orders - Shopify" account in your books
Alternatively, link the cash payment to the specific order or orders to credit "Accounts receivable (A/R) - cash orders - Shopify"
Sales and fees for non-integrated sales channels and payment processors
If a sales channel isn't integrated, we pull sales data through the payment processor. If neither the sales channel nor the payment processor is integrated, we pull the sales data on a net basis based on bank deposits.
At year-end, we'll request a breakdown of sales and fees to ensure accurate reporting through a year-end journal entry.
This JE is initiated and taken care of by our team.
Bank and credit card transactions
Your bank and credit card transactions are automatically synced through our banking integration.
Most of your transactions are automatically categorized (that is, a JE is recorded) based on our ecommerce-specific chart of accounts and our expansive vendor database from working with thousands of brands. Learn more in Understanding your Chart of Accounts.
For specific transactions, you can recategorize the transaction by clicking on the category on the Transactions page and typing in the new category. Categories that come from your integrated apps are Automated Journal Entries, so those stay as they are. Learn more in Categorizing & reviewing transactions.
Payroll with Gusto
If you use Gusto as your payroll provider, we automatically record all JEs related to salary, employer taxes, fees, and benefits directly from the data we import from Gusto.
Bills and payables from Settle or Bill.com
We'll automatically sync the data on your vendor bills from Settle or Bill.com and map them to the correct category in your P&L or Balance Sheet.
4. Customized Journal Entries
There are also various JEs that can be created or adjusted right in Finaloop.
Adjusting the treatment of specific Shopify orders
On the Orders page, you can adjust the treatment of specific orders. Select the relevant orders and click Actions to choose what you want to apply. For one or multiple orders, you can:
Add deductions
Link them to one or multiple payments with Link payment
Void orders with Void
Close uncollected or overcollected balances with Close uncollected balance or Close over-collected balance
Mark an order as a product giveaway with Mark as giveaway
Mark an order as COGS only, with no corresponding sales (for example, replacement orders or exchanges), with Mark as COGS only
Wholesale and B2B invoices (accounts receivable)
When you create invoices on the Invoices page, a JE is automatically recorded debiting your accounts receivable and crediting sales for the specific sales category you selected in your invoice (for example, Sales - Wholesale).
You can also add discounts, shipping, and tax charges to the invoices to adjust the JE accordingly.
When linking invoices to payments in your bank account, we debit your bank account and credit accounts receivable.
You can also flag invoices as uncollectible to recognize a loss in your books, or mark invoices as void to remove the impact of the invoice on your books entirely.
In addition, you can add general adjustments (such as deductions) for one or multiple invoices, and link them to one or multiple payments, automatically creating the corresponding JEs.
Read more in Managing B2B and wholesale invoices in Finaloop.
COGS and inventory
Finaloop makes it easy to manage inventory and COGS journal entries no matter which inventory method you use in your books.
Purchase-based COGS
Inventory transactions are automatically recorded as COGS.
At year-end, we'll request your year-end inventory balance and record the adjusting JE based on reported values.
This JE is initiated and taken care of by Finaloop.
Learn more in How purchase-based cost of goods sold works in Finaloop.
Sales-based COGS
Inventory-related purchases are recorded as inventory. COGS are recorded automatically for Shopify or Amazon sales.
You can create an adjusting JE for other sales channels, or to record other inventory or COGS adjustments, including dead inventory, product giveaways, or product donations. Here's how:
Go to Inventory → COGS.
Click Report per channel in the top right corner.
In Type, select the type of JE you want to add: COGS, Dead inventory, Product giveaways, or Product donations.
In Period, enter the period the JE should apply to. You can select a specific day, or choose a month or range of dates to spread the JE over multiple days.
In Amount, enter the amount of the JE:
COGS: Add a positive number to increase (debit) product COGS and decrease (credit) inventory, or a negative number to do the opposite.
Dead inventory: Add a positive number to increase (debit) dead inventory and decrease (credit) inventory.
Product giveaways: Add a positive number to increase (debit) product giveaways, a marketing expense, and decrease (credit) inventory.
Product donations: Add a positive number to increase (debit) donations and decrease (credit) inventory.
Your entry now appears on the COGS page and in your books for the period you chose.
You can also record a JE to adjust your inventory balance to better align with a physical inventory count:
Go to Inventory → Physical counts.
Click New count to enter the adjusted inventory balance. A JE debiting or crediting inventory and COGS, as relevant, is recorded automatically based on the updated inventory value you provide.
Learn more in How sales-based cost of goods sold works in Finaloop.
InventoryIQ
InventoryIQ, Finaloop's inventory management product, records JEs as your inventory moves:
Inventory JEs are recorded automatically when a purchase order (PO) is created: increasing (debiting) inventory and increasing (crediting) vendor rolling balance, a payable account.
COGS JEs are recorded when inventory is sold: increasing (debiting) COGS and decreasing (crediting) inventory.
Adjustments (for giveaways, donations, dead inventory) can be recorded for each specific SKU manually or by uploading a CSV with SKU details, triggering the necessary journal entries.
Learn more in InventoryIQ: Everything you need to know.
You can also record a JE to adjust your inventory balance to better align with a physical inventory count:
Go to Inventory → Physical counts.
Click New count. If a menu opens, choose Create new count.
Select the relevant Warehouse and enter the adjusted inventory balance for the SKUs that need adjusting. A JE debiting or crediting inventory and COGS, as relevant, is recorded automatically based on the updated inventory value you provide.
Prepaid expenses and accruals
Need a JE to amortize a prepaid expense or record an accrued expense?
With Finaloop's Spread feature, you can take full control of when expenses show up in your P&L or Balance Sheet by matching them to when you actually benefited from the expense you paid for. This allows you to manage ongoing transactions related to prepaid expenses or to accrue specific transactions to an earlier date.
It creates a JE in a much more intuitive way, while still giving you complete control over how and when your expenses show in your P&L and Balance Sheet.
For example, in January you pay a 6-month subscription fee for a software subscription that you want to amortize over the 6-month period. In Finaloop that's one task: select the transaction and enter the start date and end date. JEs are then created automatically, amortizing this prepaid expense equally over the 6 months on a daily basis. In traditional accounting software, this usually means creating 6 separate JEs, with the full month's amortization recorded on a monthly basis.
Note: Spread is available for customers using the accrual method of accounting.
Here's how to record this:
Go to Transactions.
Find the relevant transaction that needs to be spread or accrued to a different date, and click its category.
Click More actions, then select Spread transaction.
Follow the steps in Recording accrued and prepaid expenses for specifics on accrued and prepaid expenses.
For prepayments or balances that were paid before you joined Finaloop, we'll request the data as part of our Balance Sheet creation process and manage the opening balance JEs.
Recording transactions from an external bank account or credit card
On the Transactions page, you can report business transactions paid from or deposited in accounts that aren't connected to our banking integration. Here are the most common examples of when you should be recording business transactions:
Business expenses paid by the owner of the business, a related business, an employee or a contractor (even if the business will reimburse them)
Business income received by the owner (for example, in a personal account) or by a related business
Expenses paid through a third-party lender directly to a supplier
Business transactions paid from, or received in, an account that isn't synced to Finaloop (either through an integration or through a CSV upload)
Shared services: for example, if an expense is paid by a related business but part of the expense is for your business and part is for the related business, report the part that relates to your business
Utilities, home office or car expenses paid directly by the owner that are partly for business use
Cash transactions that relate to the business
If any of these cases apply, use the Report transaction button on the Transactions page to add the transaction to your books:
Click Report transaction and follow the questions to ensure a JE gets properly recorded.
When you report expenses, they generally create a liability, or a loan, for the business. For example, if the founder used their personal bank account to buy office supplies, adding this transaction would create the following JE:
Debit Office supplies in the P&L
Credit a new loan account, Due-to owner
When or if the amount is reimbursed by the company, the loan is debited accordingly
Reporting income that was paid to a personal account creates an asset, or a receivable, for the business. To determine the accurate JE to record, we'll ask a series of questions and create the JE based on your responses:
Debit loan receivable to a related party, called Due-to-from owner
When or if the income is transferred to the business, the loan is credited accordingly
To learn more, check out Reporting transactions.
Bills (accounts payable)
When creating bills on the Bills page, a JE is automatically recorded debiting the relevant expense account and crediting accounts payable.
When linking bills to payments in your bank account, we credit your bank account and debit accounts payable.
Learn more about adding and managing bills in Managing your bills (payables).
Payroll for non-connected payroll providers
If you process payroll with a provider that isn't integrated with Finaloop, our system will ask you for specific inputs as part of a tailored flow to get all the numbers we need to record everything accurately in your books. After the flow is completed for each payroll cycle, our system automatically translates the answers into JEs.
This flow replaces the need for CPAs to add manual journal entries, and takes only a few minutes every month.
If you use Gusto, your JEs are fully automated.
Equity adjustments
Need to adjust equity?
Go to Report center, and under Operational, Tax & Payroll, open Owners Table.
Provide the relevant details, and our team will ensure JEs are accurately recorded.
5. Manual Journal Entries
Manual Journal Entries are the entries that don't come from an integration or one of the built-in tools. You can post them yourself in Journal entries, and our team records loans, fixed assets, and year-end and other adjustments for you.
Posting a journal entry yourself
If you see Journal entries under Accounting tools in your sidebar, you can post your own entries:
Click New journal entry.
Enter the Date, Accounting method (Cash, Accrual or Both), Currency, Name, and, if you'd like, a Memo.
For each line, choose the Account, enter a Debit or Credit amount, and add a Description if you'd like. Click Add line to add more lines.
Check that the totals show Balanced. An entry needs at least two lines, and its debits and credits must match.
Add any supporting files with Add attachments.
Click Post, or click Save as draft to finish it later.
You'll see "Journal entry posted", and the entry appears on the Active tab. Drafts wait on the Drafts tab until you post them.
Important: Finaloop automatically reconciles your loans to keep your books accurate. Once you post a journal entry to a loan account, automatic reconciliation stops applying to that loan, and you'll be asked to confirm with Post anyway first. If you'd rather keep it automated, ask our team to record the entry.
A few things to know when you're working with your entries:
A posted entry can't go back to draft, but you can open it from the Active tab and choose Edit or Delete, or use Duplicate to start a new entry from it.
Deleted entries move to the Deleted tab, where you can choose Restore.
Accounts Finaloop reconciles automatically are grayed out and don't accept manual journal entries. Contact our team to request a change to one of those accounts.
Dates in a closed (locked) period can't be selected, and entries in a locked period or marked Locked by Finaloop can't be changed. Contact our team if one of those needs an update.
If you don't see Journal entries in your sidebar, send the details to our team and we'll take care of the entry for you.
Loans
Ecommerce loans can be notoriously tricky and complex, especially when it comes to revenue-based loans or merchant cash advances instead of traditional loans.
At Finaloop, we have a team specializing in the accounting treatment of all different types of loans, cash advances, credit lines, interest, and financing fees, and we handle all the loan JEs for you.
Loans are typically detected and categorized automatically, requiring minimal manual work from you.
Where relevant, our team will ask for the relevant loan details and record the JEs for principal payments, interest expense, and financing fees, ensuring the loans are accurately reported for accounting and tax purposes.
Read more in How Finaloop tracks your business loans.
Ecommerce loans from PayPal Working Capital, Stripe Capital, and Shopify Capital are all recorded automatically by Finaloop.
Fixed asset depreciation and intangible amortization
For fixed asset or intangible balances that were paid before you joined Finaloop, we'll request the data as part of our Balance Sheet creation process and manage the opening balance JEs.
For new fixed asset purchases, when you categorize the transaction as a fixed or intangible asset on the Transactions page, Finaloop asks for the details it needs, such as the total cost and whether you paid in installments, and records the purchase JEs and depreciation schedule based on your input.
Year-end and other adjustments
Do you have other JEs you want added, such as year-end adjustments, advances from customers, loan capitalizations, or business acquisitions? Post the entry yourself in Journal entries, or:
Contact our bookkeeping team via chat or email.
Provide details about the adjustment.
We'll review and process the entry to ensure it aligns with your financial reports.
Related articles
Need help?
Not sure if a journal entry is needed? Contact our support team via chat or at [email protected]. Our bookkeeping experts are ready to assist you in keeping your books accurate, tax-ready, and hassle-free.
